SELECT
u.USER_NAME,u.USER_ID AS RID,tu.RANK AS RANK,tu.TEAM_ID as TEAMID
FROM
bs_user u
JOIN bs_team_user tu USING (USER_ID)
JOIN bs_team_user tu1 USING (TEAM_ID)
WHERE
tu1.USER_ID = 284
AND u.USER_STATUS = 'A'
SQL语句:SELECT u.USER_NAME,u.USER_ID AS RID,tu.RANK AS RANK,tu.TEAM_ID as TEAMID FROM bs_user u JOIN bs_team_user tu USING (USER_ID) JOIN bs_team_user tu1 USING (TEAM_ID) WHERE tu1.USER_ID = 284 AND u.USER_STATUS = 'A' 结果: 李四284916 张三314116 陈倩253118 李四