Laravel多模型Eloquent关联咨询：三维中间表groups_roles_users处理方案

Hey there! Let's figure out how to handle this three-way relationship in Laravel Eloquent. From what you described, your setup uses a groups_roles_users pivot table that links users to a specific group-role pair (via the groups_roles_id field), right? And there's no direct user-group or user-role pivot table. Here's how to make this work cleanly with Eloquent:

1. First, Create a GroupRoles Model #

Since groups_roles_id references a combination of a Group and Role (I assume you have a groups_roles table connecting those two), you'll need a model to represent that group-role pair. This acts as a bridge between your User model and the Group/Role models.

// app/Models/GroupRoles.php
namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class GroupRoles extends Model
{
    protected $table = 'groups_roles';
    public $timestamps = false; // Omit this if your table has created_at/updated_at

    // Link to the associated Group
    public function group()
    {
        return $this->belongsTo(Group::class);
    }

    // Link to the associated Role
    public function role()
    {
        return $this->belongsTo(Role::class);
    }

    // Link to all Users assigned this group-role pair
    public function users()
    {
        return $this->belongsToMany(
            User::class,
            'groups_roles_users',
            'groups_roles_id',
            'user_id'
        );
    }
}

2. Define Relationships in Your Core Models #

Now update your User, Group, and Role models to work with this setup:

User Model #

Add relationships to access the group-role pairs, plus convenient shortcuts to directly get associated Groups and Roles:

// app/Models/User.php
namespace App\Models;

use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable
{
    // ... existing code ...

    // Get all group-role pairs assigned to this user
    public function groupRoles()
    {
        return $this->belongsToMany(
            GroupRoles::class,
            'groups_roles_users',
            'user_id',
            'groups_roles_id'
        );
    }

    // Get all Groups the user is part of (via group-role pairs)
    public function groups()
    {
        return $this->belongsToMany(Group::class, 'groups_roles_users', 'user_id', 'groups_roles_id')
                    ->join('groups_roles', 'groups_roles.id', '=', 'groups_roles_users.groups_roles_id')
                    ->select('groups.*');
    }

    // Get all Roles the user has (via group-role pairs)
    public function roles()
    {
        return $this->belongsToMany(Role::class, 'groups_roles_users', 'user_id', 'groups_roles_id')
                    ->join('groups_roles', 'groups_roles.id', '=', 'groups_roles_users.groups_roles_id')
                    ->select('roles.*');
    }
}

Group Model #

Add relationships to access roles, group-role pairs, and associated users:

// app/Models/Group.php
namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Group extends Model
{
    // ... existing code ...

    // Get all Roles available in this group
    public function roles()
    {
        return $this->belongsToMany(Role::class, 'groups_roles');
    }

    // Get all group-role pairs for this group
    public function groupRoles()
    {
        return $this->hasMany(GroupRoles::class);
    }

    // Get all Users in this group (across all roles)
    public function users()
    {
        return $this->belongsToMany(User::class, 'groups_roles_users', 'groups_roles_id', 'user_id')
                    ->join('groups_roles', 'groups_roles.id', '=', 'groups_roles_users.groups_roles_id')
                    ->where('groups_roles.group_id', $this->id)
                    ->select('users.*');
    }
}

Role Model #

Similar to the Group model, add relationships for groups, group-role pairs, and users:

// app/Models/Role.php
namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Role extends Model
{
    // ... existing code ...

    // Get all Groups this role is available in
    public function groups()
    {
        return $this->belongsToMany(Group::class, 'groups_roles');
    }

    // Get all group-role pairs for this role
    public function groupRoles()
    {
        return $this->hasMany(GroupRoles::class);
    }

    // Get all Users who have this role (across all groups)
    public function users()
    {
        return $this->belongsToMany(User::class, 'groups_roles_users', 'groups_roles_id', 'user_id')
                    ->join('groups_roles', 'groups_roles.id', '=', 'groups_roles_users.groups_roles_id')
                    ->where('groups_roles.role_id', $this->id)
                    ->select('users.*');
    }
}

3. Using the Relationships #

Now you can easily query the relationships like this:

• Get a user's groups and their associated roles:

$user = User::with('groupRoles.group', 'groupRoles.role')->find(1);

foreach ($user->groupRoles as $groupRole) {
    echo "Group: {$groupRole->group->name} | Role: {$groupRole->role->name}\n";
}

• Get all groups a user belongs to:

$userGroups = $user->groups;

• Get all users in a specific group with a specific role:

$group = Group::find(1);
$adminUsers = $group->groupRoles()->where('role_id', 2)->first()->users;

Why This Works #

Your groups_roles_users table doesn't directly link three models—it links users to a pre-defined group-role combination (stored in groups_roles). By creating the GroupRoles model, you give Eloquent a way to represent that combination, making it possible to build clean, maintainable relationships between all three core models.

内容的提问来源于stack exchange，提问作者erezt