直接上代码,有需要可以做参考

public function getOldUserQipuYearPage($map,$field,$map1,$field1,$year,$perpage=7)
{
    if(!$year){
        $year = date('Y');
    }
    $sql1 = DB::connection('mysqlutf8')
        ->table('kago.userclass_'.$year.' as a')
        ->leftJoin('kago.classitems as b','a.itemid','b.id')
        ->where($map)
        ->select($field);
    $query = DB::connection('mysqlutf8')
        ->table('kago.userclass_'.($year-1).' as c')
        ->leftJoin('kago.classitems as b','c.itemid','b.id')
        ->where($map1)
        ->select($field1)->unionAll($sql1);
    $querySql = $query->toSql();
    $result = DB::connection('mysqlutf8')
        ->table(DB::raw("($querySql) as d"))->mergeBindings($query)
        ->orderByDesc('d.f_time')->paginate($perpage);

    return $result;
}