Query building with Eloquent Models

How do I build the below query with Eloquent Models?

select users.*, posts.* from users, posts where users.id = 1 and users.id = posts.user_id and posts.status = 'draft'

Level 75

There are actually examples in the chapter on relationships.

https://laravel.com/docs/8.x/eloquent-relationships

1 like

Level 75

$user = User::with(['posts' => function ($query) {
    $query->where('status', 'draft');
}])->findOrFail(1);

1 like

Level 2

What about if I wanted to build the query with the authenticated user? Is this how I will go about it?

auth()->user()->with(['posts' => function($query) { 
     $query->where('status', 'draft');
}])->get();

NB: Would have tried this out myself to see if it works, but currently in transit and typing this from my phone.

Best Answer

Level 75

auth()->user()->load(['posts' => function ($query) { 
     $query->where('status', 'draft');
}]);

1 like

Level 2

If I may ask, in your first answer, you used with(). Why was it appropriate for the first answer and not the second? Thanks.

Level 75

You use load() when the parent model has already been retrieved. If not you need to use with()

Level 2

Thanks so much for taking your time to explain. It's so much appreciated. Will read more on the topic.

Please or to participate in this conversation.