$list = $Form->Table('hfx_user w')->join('(select * from f_shop ) t ON w.fxs_store=t.shopid')->where($map)->field('w.id,w.fxs_store,w.username,t.shopid,t.shopname,IFNULL(t.createtime,desc)')->limit($Page->firstRow. ',' . $Page->listRows)->order('createtime desc')->select(); 最佳答案
