How to Get Role's Permissions via relations?

[SaeedSoltoon]

Hi, when I call this, I get empty result from role.

public function getAllUsersWithAllTheirRolesAndPermissions(): Collection {

return User::with(['roles:name', 'roles.permissions'])->get();

}

And this is my table data.

and this is the result of running controller.

{ "status": 200, "data": [ { "id": 1, "first_name": "super", "last_name": "admin", "phone_number": null, "email": "[email protected]", "email_verified_at": "2021-09-22T11:39:13.000000Z", "is_active": true, "language": "en", "deleted_at": null, "created_at": "2021-09-22T11:39:13.000000Z", "updated_at": "2021-09-22T11:39:13.000000Z", "roles": [ { "name": "superadmin", "permissions": [] } ] }, { "id": 2, "first_name": "test", "last_name": "test", "phone_number": "123", "email": "[email protected]", "email_verified_at": null, "is_active": true, "language": "en", "deleted_at": null, "created_at": "2021-09-22T12:02:46.000000Z", "updated_at": "2021-09-22T12:02:46.000000Z", "roles": [ { "name": "agent", "permissions": [] } ] } ] }

Thanks.

[erikn69]

Maybe because you are removing id in roles, and that's why laravel can't build the relationship

[SaeedSoltoon]

Thanks for your reply. this is my role class, and i make changes in config file to point to this class.
I didnt remove anything. i just started from scratch.

namespace App\Models;
use Spatie\Permission\Models\Role as SpatieRole;
class Role extends SpatieRole
{
    protected $hidden = ['pivot'];
    public $guard_name = 'web';
}

what's wrong with it?

[erikn69]

return User::with(['roles:name', 'roles.permissions'])->get();

Here you are removing the id, id is used for relation loads, must be roles:id,name

[SaeedSoltoon]

Thanks.