Get all the users and their businesses in one query with a relationship

I have a relationship User->Business. I want to get all the row of the user and the business in one query. i.e. $query = User->Business, should give me something like this.

[
user=>[
		....
	]
business =>[
		...
	]
]

I want to get all the users and their businesses in one query

Nakov

4 years ago

Best Answer

Level 73

In your User model you should have the relationship method:

public function business()
{
	return $this->hasMany(Business::class);
}

and then eager load them:

$users = User::with('business')->get();

foreach ($users as $user)
{
	dd($user); // will have the user + business
}

https://laravel.com/docs/9.x/eloquent-relationships#eager-loading

kachi_dk

4 years ago

Level 1

@Nakov Thanks.

kokoshneta

4 years ago

Level 27

If each user has (or can have) more than one business, you cannot get users with all their related business in one query – SQL doesn’t work like that. You’ll need two queries: one to fetch the users, and one to fetch the businesses. Nakov’s answer is the easy Eloquent way to do this in a single line, but it does run two queries under the hood.

Please or to participate in this conversation.