[PHP知识库]thinkphp5 mysql union 子查询用法

db("task1_pj")
->where("suid",$id)
->union(
    db("task2_pj")
    ->where("suid",$id)
    ->select(false)
    ,true
)
->order("create_time desc")
->limit(100)
->select();

union

$sql =  db("task1_pj")
        ->where("suid",$id)
        ->union(db("task2_pj")->where("suid",$id)->select(false),true)
        ->order("create_time desc")
        ->limit(100)
        ->buildSql();
$history = db("user")
           ->alias("a")
           ->join([$sql=> 'b'], 'a.id = w.b.uid')
           ->field("b.*,a.nickname,a.avatar")
           ->select();

子查询