$result = $mod->alias('a') ->field('a.bfrid,a.nd,b.*') ->join('LEFT JOIN tablename as b ON a.bfrid=b.id') ->limit($page->firstRow,$page->listRows) ->where("departno=%d",array($departno)) ->group('b.id') ->select();
ThinkPHP 多条件查询
最新推荐文章于 2024-07-15 17:00:02 发布