tp5 union查询加分页加补充数据

两张相似的数据表进行联合查询，并进行分页处理，并对分页后的数据增加数据元素：

代码示例：

$a = model('orderTemporary')->field(categoryid,uid,productname,enproductname,enorderdesc,orderdesc,status,createtime,orderamount')->where(['status'=>['<>',0]])->buildSql();
$e = model('order')->field('categoryid,uid,productname,enproductname,enorderdesc,orderdesc,status,createtime,orderamount')->where(['status'=>0])->union($a)->buildSql();
$order = Db::table($e.' a')
            ->order('createtime desc')
            ->paginate(7)->each(function($item,$key){
                $item['categoryname'] = model(category')->where(['id'=>$item['categoryid']])->value('categoryname');
                $item['sernum'] = model('user')->where(['id'=>$item['uid']])->value('num');
                return $item;
            });
$data = $order->toArray()['data'];
$pagehtml = $order->render();
$this->assign('pagehtml', $pagehtml);
$this->assign('rilst', $data);