Location with District

Hello everyone,
I would need your insights on a point where I’m stuck.
I have a database with a location on each line linked to a profile.
Basically, on my home page, I would like to display the cities linked to the profile in a repeating group. So far, I’ve got this part figured out.
However, what I’m struggling with is determining the number of profiles per city. The only result I manage to obtain is the number of profiles within a city based on a certain distance, which doesn’t make much sense.
Furthermore, if we click on a city with districts, like Marseille in France for example, how can I generate the districts in Bubble?
Thank you in advance if you have any suggestions.