How to select posts for a specified city using Many to Many?

Question

Laravel

There are three tables
- posts
- cities
- post_city

How do I select posts only for the specified city? I did not find a solution in the documentation.

I tried to do it through the join () method when selecting posts (Post:: where ()-> join (), but then the data selection configured in the model, for example, in hasMany () stops working.

Answer 1

The task is the most trivial. You need a many-to-many relationship , whereHas and no joins. In the dock, everything is written in such detail and with examples that it’s impossible to figure it out ... well, that means it’s just too early)