i'm using entrust package Basically I just want to count users based on roles something like this:
$users = User::whereHas('roles')->count();
dd($users);
naturally what i'm getting is the count of users with roles, but what i'm trying to get is something like this..
expected
**roles count**
admin 4
user 2
$role_name $User_withthisRole_count
Edited: i want something dynamic, i don't want to add roles manually
not sure what to do..
Use withCount():
$roles = Role::withCount('users')->get();
foreach($roles as $role) {
// $role->users_count
}
$users = User::where('roles','user')->count();
$admins = User::where('roles','admin')->count();
Use Laravel groupBy
User::select('roles', DB::raw('count(*) as count'))
->groupBy('roles')
->get();
You could do something like this:
$roles = Role::pluck('name');
foreach ($roles as $roleName) {
$userCount = User::whereHas('roles', function($query) use($roleName) {
$query->where('name', $roleName);
})->count();
}
users where roles = (select * where name = admin))
$roles = Role::pluck('name')->toArray();. According to entrust documentation, you also may do this $admins = User::withRole('admin')->get(); // or maybe with a relationsship $company->users()->withRole('admin')->get();i had to do a raw query, thanks all for the help
DB::select( DB::raw("select name,count(name) AS count,display_name from roles a,
role_user b where a.id=b.role_id group by name") )
This worked for me
$roles = User::where('role_id',$roles->id)->count();
My relation is a one to many
