with relation in laravel query code example
Example 1: laravel where on relation
Event::whereHas('participants', function ($query) {
$query->where('IDUser', '=', 1);
})->get();
Example 2: where query from relation table in laravel
UserModel::whereHas('attachments', function ($attachmentQuery) {
$attachmentQuery->where('level', 'profile_level');
})->get();
If you want from already queried model get specific attachments then write
$userModel->attachments()->where('level', 'profile_level')->get();
it is impossible to query both UserModel and AttachementModel in single query,
it must be at least two queries. Even fancy
UserModel::with('attachments')->get();,
which returns user with all attachments, do internally two queries.
OR:
I noticed that you can define relation constraints within with method
UserModel::with(['attachments' => function ($attachmentQuery) {
$attachmentQuery->where('level', 'profile_level');
}])->get();