sql语句 left outer join。。on。。语句 left outer join。。on。。语句 SELECT u.*,r.ID AS RID,r.ROLE_NAME,r.ROLE_DESC FROM role r LEFT OUTER JOIN user_role ur ON r.id = ur.RID LEFT OUTER JOIN user u ON ur.UID = u.id