联表查询一般用left join实现，比如:

select a.*,b.* from user a left join info b on a.id=b.userid;