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
);