Directory organization in MySQL. How right?

Question

PHP

Hello.
Perhaps the question has been raised before. Googled. But I don't know what it's called properly. Because the search results do not satisfy the question.
It is required to make a catalog of cell phone stores.
On the page of each store there is a field "Manufacturer's phones for sale". Each store, of course, has its own set... Some only have Nokia and Samsung, while others have Apple, Samsung, HTC... And when you click on each of the brands, we should get to a page with a list of stores that sell this brand of phones.
The question is how to properly organize the database in this case?
And how should one select from the tables so that each store has its own set of manufacturers?
Many thanks in advance.

Answer 1

Standard many-to-many relationship. Store table, manufacturer table, store-manufacturer relationship table.