Laravel UNION联合查询并分页:
Union:对两个结果集进行并集操作,不包括重复行,同时进行默认规则的排序;
Union All:对两个结果集进行并集操作,包括重复行,不进行排序;
$xk =  DB::table('xiaokes')->select(['id','xk_name as name','xk_teacher_id as tid','ke_type','created_at']) 
           ->where('xk_teacher_id',$id); 
 
       $query =  DB::table('zhuanlans')->select(['id','zl_name as name','zl_teacher_id as tid','ke_type','created_at']) 
           ->where('zl_teacher_id',$id)->union($xk); 
 
       $querySql = $query->toSql(); 
       $result = DB::table(DB::raw("($querySql) as a"))->mergeBindings($query) 
           ->orderBy('created_at','desc')->paginate(10);