多表关联

SELECT team.buyer_id,accout.happiness FROM `t_team` as team LEFT JOIN t_account as accout on accout.buyer_id=team.buyer_id LEFT JOIN t_buyer_user as user on team.buyer_id=user.id;