ThinkPHP ¶àÌõ¼þ²éѯ

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