mysql 多表 查询

select r.*,c.username from report r left join
client c on  r.clientId=c.id;




select s.*,c.name,n.name from star s 
left join clubteam c on s.clubTeamId=c.id 
left join nationalteam n on s.nationalTeamId=n.id where s.id=15;