Duplicate users appearing in Drupal Admin "people" view

[jilladams]

Describe the defect

https://dsva.slack.com/archives/CT4GZBM8F/p1698964741773909

In the People page of Drupal Admin, I'm seeing dupe rows for several people, with identical user IDs: https://prod.cms.va.gov/admin/people?user=&status=1&role=content_publisher&workbench_access_section__section=194.

I got here while looking for a Content Publisher test user with Sitewide Content section permissions. I didn't check other roles / sections to see if this happens other places. It might.

To Reproduce

Steps to reproduce the behavior:

1. As Drupal admin, go to People
2. Filter by Content publisher role
3. Filter by Sitewide Content Team section
4. See multiple duplicate rows of users, with the same User ID

AC / Expected behavior

Each user should appear one time in any list of users

Screenshots

[TroyA6]

Possibly VIEW related. Searching all Active accounts, Carl Dickerson (for example) only appears once. In the above shot, Carl appears twice...

[TroyA6]

Searching for an individual within the SITEWIDE CONTENT TEAM (such as Marci McGuire), where Sitewide Content Team is a filter, results in duplicate results -

While searching for an individual (such as Marci McGuire), where NO SECTION has been selected, results in a single return:

[ndouglas]

The view generates an SQL query with a LEFT JOIN on users against section associations, where there's an array of possibilities on the right. The number of rows for each user will correspond to the number of their section memberships within the array of possibilities. We just need to click the "DISTINCT" checkbox behind Query Settings, I believe.