Laravel Polymorphic Many To Many Fetch By Specific Association

Question

I have a simple many-to-many polymorphic relationship (if such thing is possible):

Authors: On Blog we have Posts => Authorable On Magazine, Articles => Authorable

Both relationships work as expected/documented. What I need is to fetch All authors for a specific Post category

All I have is: Post::category('blue') Collection (category being a scope). Based on that, what is the best way to get Authors that wrote "Blue Posts" ?

Exactly ... I want a collection of Authors that has Posts in Blue category — Fernando Barrocal, Mar 01 '17 at 20:37

score 2 · Accepted Answer · edited May 23 '17 at 11:53

You'll want to look into using the has() and whereHas() query methods within your scope. See Laravel - Eloquent "Has", "With", "WhereHas" - What do they mean? for a detailed explanation on using them.

Basically would look something like this:

$authorsOfBluePosts = Author::whereHas('posts', function ($postsQuery) {
    $postsQuery->whereHas('category', function ($categoryQuery) {
        $categoryQuery->where('name', 'blue');
    });
})->get();

Laravel Polymorphic Many To Many Fetch By Specific Association

1 Answers1