How to filter many to many structure in Laravel

Question

I got a many to many user and role structure

users
id
name

roles
id
name

role_user
user_id
role_id

Model

User.php

public function roles() {
    return $this->belongsToMany('Role');
}

Role.php

public function users() {
    return $this->belongsToMany('User');
}

There are two data admins and members in roles table, I would like to know to to filter users which role is admins.

user1669496 · Accepted Answer · 2017-01-24 13:49:28Z

25

This should give you all users who are admins.

$users = User::whereHas('roles', function($q) {
    $q->where('name', '=', 'admins');
})->get();

You can see more information on the has() method at http://laravel.com/docs/eloquent#querying-relations

answered Jan 27, 2014 at 14:11

user1669496

33.3k9 gold badges76 silver badges65 bronze badges

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

1 Answer 1