Pivot table with 3 tables (subscriber, status, account)

There's no way of defining a 3-way relationship. You can relate just 2 models and the 3rd one as part of the pivot table.

// App/Group.php
public function subscribers() {
    return $this->belongsToMany(App\Subscriber::class)->withPivot('status_id');
}

public function statuses() {
    return $this->belongsToMany(App\Status::class)->withPivot('subscriber_id');
}


// App/Subscriber.php
public function groups() {
    return $this->belongsToMany(App\Group::class)->withPivot('status_id');
}

public function statuses() {
    return $this->belongsToMany(App\Status::class)->withPivot('group_id');
}

// App/Status.php
public function groups() {
    return $this->belongsToMany(App\Group::class)->withPivot('subscriber_id');
}

public function subscribers() {
    return $this->belongsToMany(App\Subscriber::class)->withPivot('group_id');
}

Oh, I see, did not know that.

But how do I get subscriber in group with specific status? Thanks!

Group::find(1)->subscribers()->...

You should have this relationship

one group hasMany subscribers one subscriber belongsTo a group one subscriber hasOne status one status belongsToMany user

@homoky

If you want the subscribers of a group with a specific status

$subscribers = Group::find(1)->subscribers()->wherePivot('status_id', 2)->get();