它的核心在于用戶直接和權限掛鉤  例子：  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 |