3 Way Many To Many

Well you can take a look at hasManyThrough

Source: http://laravel.com/docs/5.1/eloquent-relationships#has-many-through

within that user-organisation pair

You have to create a model to represent this user-organisation pair. Then :

• User has many UserOrganisation
• UserOrganisation belongs to an User
• Organisation has many UserOrganisation
• UserOrganisation belongs to an Organisation
• Many to many relationship with pivot table between Role and UserOrganisation

Then display the user roles :

$user = User::find(1);

foreach ($user->user_organisations as $user_organisation)
{
    $user_organisation->organisation->name;

    foreach($user_organisation->roles as $role)
    {
        $role->name;
    }

}

It also works starting from an organisation and listing users with their roles within the organisation.

@bobby - Thanks, I have taken a look at that and I'm not convinced its the correct solution - In the docs the example is Countries, Posts, Users - This goes under the assumption that a User belongs to only one country and that that link is set on the Users table (country_id). In my example, Countries would be organisations, here, my User can belong to Many organisations, but when he does - his roles change.

I'm really quite new at this, so am I missing something ?

HasManyThrough doesnt work with many to many relationships. Look at my answer above.

Yup... pmall's way is what i'll go with.

I've seen another similar solution, also requiring a fourth model. In that other implementation, however, the fourth model was the glue... so User, Organization, and Role, all connected to that fourth model. That felt clunky to me.

I like pmall's way better, I think. Creating the abstraction between just 2 (User and Organization) and then using that abstract model to create the relationship to roles. This feels like it mirrors the way I'd want to go at it programmatically anyway... first, let's make sure the user is a member of the organization... then let's check his or her roles to see if the action they are trying to take it allowed.

Thanks guys!

Use belongsToMany relationship