SELECT
u.username,r.name,f.code
FROM
auth_function f
LEFT OUTER JOIN role_function rf
ON f.id = rf.function_id
LEFT OUTER JOIN auth_role r
ON r.id = rf.role_id
LEFT OUTER JOIN user_role ur
ON ur.role_id = r.id
LEFT OUTER JOIN t_user u
ON u.id = ur.user_id
WHERE u.id = '297ef55962de5ba20162de5c94010001' ;