Laravel多对多带中间表关联：如何创建对应的Eloquent关联？

Got it, let's break down how to set up these Eloquent associations properly given your table structure. Since you've already started with the Provider ↔ Resolution link, let's build out the rest step by step.

1. Confirm/Refine the Provider ↔ Resolution Association #

Your ProviderResolution table isn't just a basic pivot—it has its own primary key (prid) and an extra active field. So we'll use a custom pivot model instead of Laravel's default Pivot class to make it easier to work with the subsequent User association.

In your Provider.php model:

use App\Models\ProviderResolution;

public function resolutions()
{
    return $this->belongsToMany(Resolution::class)
        ->using(ProviderResolution::class) // Tell Laravel to use our custom pivot model
        ->withPivot('active', 'prid') // Include the extra fields (including the pivot's own ID)
        ->withTimestamps(); // Add this only if your table has `created_at`/`updated_at` columns
}

Corresponding code in Resolution.php:

use App\Models\ProviderResolution;

public function providers()
{
    return $this->belongsToMany(Provider::class)
        ->using(ProviderResolution::class)
        ->withPivot('active', 'prid')
        ->withTimestamps();
}

2. Create the ProviderResolution Model #

Since this table has its own primary key and needs to link to Users, we'll create a dedicated model for it. Run this Artisan command first:

php artisan make:model ProviderResolution

Then update the model file to extend Laravel's Pivot class (instead of the default Model) and configure the table specifics:

namespace App\Models;

use Illuminate\Database\Eloquent\Relations\Pivot;

class ProviderResolution extends Pivot
{
    // Explicitly set the table name (optional if your model/table naming follows Laravel conventions)
    protected $table = 'provider_resolutions';

    // Override the default primary key from `id` to `prid`
    protected $primaryKey = 'prid';

    // Set to true if `prid` is an auto-incrementing ID (adjust if yours is non-incrementing)
    public $incrementing = true;

    // Define fields that can be mass-assigned
    protected $fillable = ['pid', 'rid', 'active'];
}

3. Link ProviderResolution ↔ User #

Your ProviderResolutionUser table creates a many-to-many relationship between ProviderResolution and User. Let's add these associations to both models.

In ProviderResolution.php:

public function users()
{
    // The second argument is the pivot table name, followed by the foreign keys for this model and the related model
    return $this->belongsToMany(User::class, 'provider_resolution_users', 'prid', 'uid');
}

In User.php:

use App\Models\ProviderResolution;

public function providerResolutions()
{
    return $this->belongsToMany(ProviderResolution::class, 'provider_resolution_users', 'uid', 'prid');
}

4. Optional: Add Convenience Nested Associations #

If you want to directly fetch Providers or Resolutions from a User (skipping the intermediate ProviderResolution step), you can add these helper methods to User.php:

// Get all Providers linked to the user through ProviderResolution
public function providers()
{
    return $this->belongsToMany(Provider::class, 'provider_resolution_users', 'uid', 'prid')
        ->join('provider_resolutions', 'provider_resolution_users.prid', '=', 'provider_resolutions.prid')
        ->select('providers.*'); // Avoid column name conflicts
}

// Get all Resolutions linked to the user through ProviderResolution
public function resolutions()
{
    return $this->belongsToMany(Resolution::class, 'provider_resolution_users', 'uid', 'prid')
        ->join('provider_resolutions', 'provider_resolution_users.prid', '=', 'provider_resolutions.prid')
        ->select('resolutions.*');
}

5. Quick Usage Examples #

• Fetch active Resolutions for a Provider:

$provider = Provider::find($pid);
$activeResolutions = $provider->resolutions()->wherePivot('active', true)->get();

• Get all Users linked to a specific ProviderResolution:

$providerResolution = ProviderResolution::find($prid);
$linkedUsers = $providerResolution->users;

• Fetch all ProviderResolutions associated with a User:

$user = User::find($uid);
$userProviderResolutions = $user->providerResolutions;

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