Thinkphp常用代码--联合查询

$userModel = M('user');//实例化用户表
$addressTable = C('DB_PREFIX') . 'address';//地址表
$user_info = $userModel
    ->alias('a')
    ->join("left join $addressTable b on a.id=b.user_id")
    ->where(array('a.status'=>1))
    ->field('a.id,a.name,a.headimg,b.province,b.city,b.area,b.address')
    ->select();