Eloquent 多对多对多 - 如何轻松加载远距离关系

2021-12-26 00:00:00 php mysql laravel eloquent

我有 3 张桌子；用户、组和权限

I have 3 tables; users, groups and permissions

在模型中，我将关系设置为belongsToMany在用户模型中:

In models I have the relationships set as belongsToMany in user model: 

public function groups() {
    return $this->belongsToMany('Group');
}

在组模型中:

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

public function permissions() {
    return $this->belongsToMany('Permission');
}

在权限模型中:

public function groups() {
    return $this->belongsToMany('Group', 'id');
}

许多用户 - 到 - 许多组许多组-对-许多权限

many users - to - many groups many groups - to - many permissions

我正在尝试获取用户拥有的所有权限，但不知道它的代码应该是什么样子.有人可以帮忙吗?

I'm trying to get all the permissions a user has, and have no clue what the code for it should look like. Can anyone help?

推荐答案

您可以这样做:

User::where('id', $id)->with(['groups.permissions' => function ($q) use (&$permissions) {
     $permissions = $q->get()->unique();
}])->first();

// then
$permissions; // collection of unique permissions of the user with id = $id

相关文章