Laravel Where Relation

gistfile1.txt

// Get me all users who have posts that are to be published in the future.
User::whereHas('posts', function ($query) {
    $query->where('published_at', '>', now());
})->get();

we can now refactor and simplify the above to the following:

User::whereRelation('posts', 'published_at', '>', now())->get();

As you can see, we have collapsed the closure into the parameter list of the whereRelation method.

you also have access to orWhereRelation, whereMorphRelation, and orWhereMorphRelation.

It is worth noting that because it uses a where clause under the hood, it would not be possible to use scopes:

User::whereHas('posts', function ($query) {
    $query->notPublished();
})->get();

Or nested where:

User::whereHas('posts', function ($query) {
    $query
        ->whereHas('tags', function ($query) {
            $query->where('name', 'Laravel');
        })
        ->where('published_at', '>', now());
})->get();

Though you should be able to use nested relations if you don't have any intermediate where clauses:

User::whereRelation('posts.tags', 'name', 'Laravel')->get();