~~~ Db::query("select a.cate_id,a.cate_name,a.icons,count(b.cate_id) AS company_count from sbzh_category AS a LEFT JOIN sbzh_company AS b ON a.cate_id=b.cate_id group by a.cate_id"); ~~~ ~~~ 參數綁定情況 Db::query("select * from think_user where id=? AND status=?", [8, 1]); ~~~ ~~~ 第二種方法 $data=Db::table('sbzh_category')->alias('a')->leftJoin('sbzh_company b','a.cate_id=b.cate_id')->field('a.cate_id,a.cate_name,count(b.cate_id) as company_count')->group('a.cate_id')->select(); ~~~