Duplicated relations when using dynamic zones
### Node Version

20.18.0

### NPM/Yarn/PNPM Version

NPM 10.8.2, Yarn 4.3.0

### Strapi Version

5.9.0 - 5.10.2

### Operating System

Linux (Debian/Ubuntu)

### Database

any (tested with SQLite/PostgreSQL)

### Javascript or Typescript

Typescript

### Reproduction URL

https://github.com/Magiczne/strapi-bug-reproducer/tree/issue-22796
Reproduction contains SQLite dabase to use. Just run `yarn develop`
User: `test@test.pl`
Password: `Test.12345`

### Bug Description

For some types populating dynamic zones does populate all elements (either drafts or published), and for some it's not (correct behavior only populating published elements)

### Steps to Reproduce

1. Create two `Advice` items
2. Add RelatedAdvices widget to each of the single types in the content slots
3. Observe API:

On `http://localhost:1337/api/investments-list?locale=ro&populate%5BbottomContent%5D%5Bon%5D%5Bwidgets.related-advices%5D%5Bpopulate%5D%5Bitems%5D%5Bpopulate%5D=seo` we see that there are 4 items inside `items` array - drafts and published

On `http://localhost:1337/api/advices-list?locale=ro&populate%5BbottomContent%5D%5Bon%5D%5Bwidgets.related-advices%5D%5Bpopulate%5D%5Bitems%5D%5Bpopulate%5D=seo` we see that there are 2 items inside `items` array - only published ones

In each of the cases there should be only published entries which are visible.

### Expected Behavior

Items array should contain only published elements

### Logs

```shell
Logs are perfectly clean on the front and the back.
```

### Code Snippets

_No response_

### Media

Advices list:
![Image](https://github.com/user-attachments/assets/602009dd-7e13-4e47-8a75-a0c4084a7483)

Investments list:
![Image](https://github.com/user-attachments/assets/08345a5c-e219-43c9-bc22-fc09024ba8bd)

### Additional information

_No response_

### Confirmation Checklist

- [x] I have checked the existing [issues](https://github.com/strapi/strapi/issues) for duplicates.
- [x] I agree to follow this project's [Code of Conduct](https://github.com/strapi/strapi/blob/develop/CODE_OF_CONDUCT.md).