Nested query using with?

Question

I wish to get all roles with users, but I want to specify the user.

It's a many to many relationship.

Role::with('users')->get();

The above gets all roles with their users, I wish to get all roles and only display a specific user next to the ones they exist in. I still want roles in which they don't exist in.

I think I need to use a nested query but cant quite get the syntax correct using 'with'.

luisandani · Accepted Answer · 2014-08-20 15:20:48Z

1

You can filter the users inside the "with", like this:

Role::with(array('users' => function($query) use ($username) {
    $query->where('user_name', '=', $username);
}));

answered Aug 20, 2014 at 15:20

luisandani

685 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Nested query using with?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related