一个表关联两次另一个表降序排序desc

xiaoxiao2021-03-01  50

public function wocaotuijian(){ $list=Db::table('xc_tuijiansum')->alias('a') ->join('xc_member me','a.uid=me.uid','left') ->where(['a.success'=>2]) ->field('a.id,me.nicheng,a.tid,a.time')->order('a.time desc')->select(); foreach($list as $k=>$v){ $n=Db::table('xc_member')->where(['uid'=>$v['tid']])->value('nicheng'); array_push($list[$k],$n); } $this->assign('list',$list); return $this->fetch('zgxc/wokao'); }
转载请注明原文地址: https://www.6miu.com/read-4199967.html

最新回复(0)