SQL多表查询

a  sys_user       user_name => user_id dept_id
b  sys_user_role  user_id   => role_id
c  sys_role       role_id   => role_name
d  sys_role_dept  role_id   => dept_id
e  sys_dept       dept_id   => dept_name parent_id dept_name
f  sys_dept       parent_id => dept_name

SELECT 
	a.user_name,
	a.user_id,
	a.dept_id,
	b.role_id,
	c.role_name,
	e.dept_name,
	f.dept_name
FROM
	sys_user AS a
	INNER JOIN  sys_user_role AS b  ON b.user_id = a.user_id
    INNER JOIN  sys_role AS c       ON c.role_id = b.role_id
    INNER JOIN  sys_dept AS e       ON e.dept_id = a.dept_id
	INNER JOIN  sys_dept AS f       ON f.dept_id = e.parent_id
WHERE
	a.user_name = 'zjzsqxyf01'