CREATE VIEW User_Role_Privilege AS
(
 SELECT u.id AS user_id, u.name AS user_name, r.id AS role_id, r.name AS role_name, p.id AS privilege_id,
 p.name AS privilege_name, p.parent_id AS privilege_parent_id, p.resource AS privilege_resource, p.url AS privilege_url,
 p.is_display AS privilege_is_display
 FROM User AS u
 JOIN User_Role AS ur ON ur.user_id=u.id
 JOIN Role AS r ON r.id = ur.role_id
 JOIN Role_Privilege AS rp ON r.id = rp.role_id
 JOIN Privilege AS p ON p.id=rp.privilege_id
);