Laravel用户、角色、权限关系实现问题

Question

我有三个模型用户、角色和权限。这些模型与其表之间存在复杂但众所周知的关系。

表及其列：

因此，每个用户只有一个角色，每个角色都有许多权限。

<?php

class User
{


public function role()
{
    return $this->belongsTo(Role::class);
    
}

public function permissions()
{
    return $this->hasManyThrough(Permission::class,Role::class);
}
}


class Role
{


public function users()
{
    return $this->hasMany(User::class);
  
}

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


class Permission
{


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

public function users()
{
    return $this->hasManyThrough(User::class,Role::class);
}
}

我可以访问

1. $用户-

除了

1. $权限-

返回sql错误：

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'roles.permission_id' in 'field list' (SQL: select `users`.*, `roles`.`permission_id` as `laravel_through_key` from `users` inner join `roles` on `roles`.`id` = `users`.`role_id` where `roles`.`permission_id` = 1) 

但为什么呢？

Answer 1

你能这样试试吗：

public function users()
{
    return $this->hasManyThrough(
        User::class,    // The model to access to
        PermissionRole::class,    // The intermediate table that connects the User with the Role.
        'permission_id',   // The column of the intermediate table that connects to this model by its ID.
        'role_id',    // The column of the intermediate table that connects the Role by its ID.
        'id',    // The column that connects this model with the intermediate model table.
        'role_id'   // The column of the Users table that ties it to the Roles. 
    );
}

我找到了这篇文章。

如果您将其与您的表格进行比较，可能会如下所示：

• audio_files表是你的用户
• 播客表是您的角色
• 订阅表是您的permission_role
• 用户表是您的权限

也许这很混乱，但请让我知道这是否有效。