// laravel count the types of users $roles = Role::pluck('name'); foreach ($roles as $roleName) { $userCount = User::whereHas('roles', function($query) use($roleName) { $query->where('name', $roleName); })->count(); }