它的核心在于用户直接和权限挂钩  例子：  user | id | username |role| | --- | --- |--- | | 1 | stephen |1,2,5 | | 2 | weronica |1,2,3 | | 3 | andrew |1,4,5,6 | role | id | rulename | | --- | --- | | 1 | 查看 | | 2 | 编辑 | | 3 | 审核 | | 4 | 数据管理 | | 5 | 删除 | | 6 | 权限管理 | 他们是多对多关系 所以可以用中间表将他们关联在一起 user | id | username | | --- | --- |--- | | 1 | stephen | | 2 | weronica | | 3 | andrew | rule | id | rulename | | --- | --- | | 1 | 查看 | | 2 | 编辑 | | 3 | 审核 | | 4 | 数据管理 | | 5 | 删除 | | 6 | 权限管理 | user_rule | user_id | role_id | | --- | --- | | 1 | 1 | | 1 | 2 | | 1 | 5 | | 2 | 1 | | 2 | 2 | | 2 | 3 | | 3 | 1 | | 3 | 4 | | 3 | 5 | | 3 | 6 |