CODEWITHSUNDEEP
laravel
aletede91
aletede91

Reputation: 1166

Get model only if relationship has data

I am working on a Laravel project and I have these two models User and Post:

user
-id
-name
-status

post
-id
-id_user
-name

What should I change from next line to have only User with at least one Post (I already created the one-to-many relationship in the models)?

$users = User::where('status', true)->get();

Upvotes: 0

Views: 84

Answers (1)

Ben
Ben

Reputation: 2245

If there is a one-to-many relationship, you can use https://laravel.com/docs/8.x/eloquent-relationships#querying-relationship-existence and do this:

User::has('posts')->whereTrue('status')->get()

If you need more power over has, you could use whereHas.

Upvotes: 2

Related Questions