How to properly organize the category structure of the site with the choice of the city?

Question

DLE

I thought about it for a long time, but I didn’t come up with anything other than how to create more than 1000 city categories and add site categories to each.

Now there is a need to create this functionality, the functionality of determining the city and displaying information for a particular city.

I can identify the city.

I want to know your opinion about the correct organization of the categories of the site with cities.

The work is planned on dle cms, do you really need to create more than 30,000 categories, if in fact there are 30 of them?
Those. 1000 cities with 30 identical categories each.

How to simplify the task?

Thank you!

Answer 1

Make the city table separate and the category_to_city table where the binding will be.