数据库多对多关联的问题

假设user_id每张表都有

select * from user a left join imgurl b on a.user_id=b.user_id left join on address c on a.user_id=c.user_id left join profession d on a.user_id=d.user_id

select * from user a  
left join user_imgurl b on a.user_id=b.user_id 
left join user_address c on a.user_id=c.user_id 
left join user_profession d on a.user_id=d.user_id 
left join imgurl e on e.uer_imgurl=b.uer_imgurl  
left join on address f on f.user_address=c.user_address  
left join profession g on g.user_profession=d.user_profession