$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;

标签: none

添加新评论