现在开发项目的sql写法——涉及很广

select
sys_company.companyid,
sys_user_roles.roleid,
sys_role_rights.menuid,
sys_menu.name
from sys_user
INNER join sys_company on sys_company.companyid=sys_user.companyid
INNER join sys_user_roles on (sys_user_roles.userid=sys_user.userid and sys_user_roles.companyid=sys_user.companyid)
INNER join sys_role_rights on (sys_role_rights.companyid=sys_company.companyid and sys_role_rights.roleid=sys_user_roles.roleid)
INNER join sys_menu on sys_menu.menuid=sys_role_rights.menuid
where sys_user.userid=10
GROUP BY sys_menu.menuid  ORDER BY sys_menu.menuid DESC
设计到5张表的查询；