php - Mysql 查询从 3 个 IDS 获取 3 个名称

Question

我有这样的设置:

表成员

id_member name  
---------------

餐 table 团队

id_team   id_leader   id_member1   id_member2
---------------------------------------------

现在我想在 html 表中显示所有团队的这些字段:id_team，领导者姓名，成员1姓名，成员2姓名

尝试使用多个选择进行多个查询，但当一名成员位于多个团队中时会出现问题，显示错误的结果(所有组合)

我想要的示例: http://oi58.tinypic.com/ao9oxi.jpg

Answer 1

尝试使用如下连接查询

select TEAM.id_team, LEADER.name, MEMBER1.name, MEMBER2.name 
from teams as TEAM 
join members as LEADER on(LEADER.id_member=TEAM.id_leader) 
join members as MEMBER1 on(MEMBER1.id_member=TEAM.id_member1) 
join members as MEMBER2 on(MEMBER2.id_member=TEAM.id_member2)