简化sql语句

Question

$sql=DB::query("select a.uid,a.username,a.email,a.regip,a.regdate,b.mobile,b.field3,b.field4,b.field5,(select c.lastvisit from ".DB::table('common_member_status')." c where a.uid=c.uid) lastvisit from ".DB::table('ucenter_members')." a left join ".DB::table('common_member_profile')." b on a.uid=b.uid");还能更简化些吗，尽量达到最简化

Answer 1

最好把select 子句中子查询变成连接来查.