sql 联表搜索

/*
*/

SELECT
	SU.*, AR.*
FROM
	`t_user_role` UR
INNER JOIN t_sys_user SU ON UR.uid = SU.t_id
INNER JOIN t_sys_auth_role AR ON UR.group_id = AR.id