合并两张不同的表的数据并分页(union)
$a = Db::name('zzz_m')->field('m_id id,m_type type,m_update time,data_type')
->where('m_user_id',3)
->buildSql();
$b = Db::name('zzz_v')->field('v_id id,v_type type,v_update time,data_type')
->where('v_uid',1)
->where('v_take_status',3)
->union([$a])
->buildSql();
$list = Db::table($b . ' a')->order('time desc')->paginate(10,true,['page'=>1]);// $c . a是零时表名
$list = json_decode(json_encode($list),true);
dump($list['data']);die;