How to set a condition for a linked table when fetching data?

Question

Laravel

A little confused. It seems like a simple question in my head, but I can not find a solution.

How to set a condition when selecting with Eloquent, which would be checked for the presence of data in the associated table. Those. I need the row to get only if it has data in the associated table.

There is withCount('myProp') which gives the number of records in the related table, but what is the right way to use it in the where condition (withCount('myProp') > 0)?

Answer 1

There is also has()
$users = User::has('posts')->get();
or

$users = User::whereHas('posts', function($q){
    $q->where('created_at', '>=', '2015-01-01 00:00:00');
})->get();