Laravel UNION联合查询并分页

public function getData($where){
        $xk = DB::table('writing_custom')
            ->where($where)
            ->select('id', 'name','created_at','status',DB::raw('"1" as type'));
        $query = DB::table('writing_system')
            ->select('id', 'name','created_at','status',DB::raw('"2" as type'))
            ->where($where)
            ->unionAll($xk);
        $querySql = $query->toSql();
        $list= DB::table(DB::raw("($querySql) as a"))->mergeBindings($query)
            ->orderBy('created_at','desc')->simplePaginate(15);
        return $list;
    }

本作品采用《CC 协议》，转载必须注明作者和本文链接