How to make a selection in a controller using pivot?

Question

Laravel

There is a table posts
id
post
----
post_categories
id
Category
---
pivot post_post_category
post_id
post_category_id

Everything works - creating, editing, deleting through models. I can not achieve a selection by post_category_id. I copied and pasted this request:

Post::with(['postCategories' => function($query) {
                  $query->wherePivot('post_category_id',$this->page);
    }])->get();

But it stupidly selects all posts without filtering by post_category_id. What did I miss? Thanks to all!

Answer 1

Normal heroes always go around:

Post::with('postCategories')->whereHas('postCategories', function($q) {
                       $q->where('post_category_id','=',$this->page); 
                   })
                   ->orderBy('created_at', 'desc')
                   ->get();