Laravel Eloquent: whereHas Deep Filtering

Filter models based on their relationship conditions.

Filter with whereHas:

Basic whereHas

php

$users = User::whereHas('posts', function ($query) {
    $query->where('is_published', true);
})->get();

php

$users = User::whereHas('posts', function ($query) {
    $query->where('is_published', true);
}, '>=', 5)->get();

php

$users = User::whereHas('posts.comments', function ($query) {
    $query->where('approved', true);
})->get();

php

$users = User::whereHas('posts')
    ->orWhereHas('comments')
    ->get();