laravel relation in query code example

Example 1: 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();

Example 2: associate laravel

When updating a belongsTo relationship, you may use the associate method. This 
method will set the foreign key on the child model:

	$account = App\Account::find(10);
	$user->account()->associate($account);
	$user->save();

When removing a belongsTo relationship, you may use the dissociate method. This
method will set the relationship foreign key to null:

	$user->account()->dissociate();
	$user->save();

Tags:

Php Example