Laravel 3表Eloquent：关系

Question

I have 3 tables

roles

id `````` |```` `` role ```````` |

1 `````` ```````` Staff

permissions

id ````````| `````````` Name ```````````` |

1 ````````````Manage All Projects

2 ```````````` Manage Clients

acces_permissions

id_permission FK | id_role FK
`````` `` 1 ```````````````````` 1

```````` 2 ```````````````````` 1

and i will have a table with

roles | permissions Name |

Staff | Manage All Projects Manage Clients |

how can o this whit this 3 Models

class roles extends Model
class permissions extends Model
class acces_permissions extends Model

Answer 1

correct me if im wrong, what you are trying to achieve is get all permissions using the role of a user ..

the easiest way is to use belongsToMany eloquent relation, in your Role model add this

public function permissions()
{
    return $this->belongsToMany('App\Permissions', 'access_permission_table', 'id_role', 'id_permission');
}

this way, when you call $role->permissions, you'll get all the permission for that role.