tp5增删改查sql

select 统计多个字段

       $where["e.type"] = $qun_type;
       $db=db("dingding_ewms")
         ->alias("e")
         ->field(["count(u.is_long_touch=1 or null)"=>"num_long","count(u.id)"=>"num_id","e.id,e.name,e.on_time,e.off_time"])
         ->join("dingding_user_count u","u.bind_qun=e.id")
         ->where($where)
         ->order("e.id desc")
         ->group("e.id");

引用http://blog.csdn.net/abountwinter/article/details/47083211

        Db::table(["member"=>"m"])
            ->field(["count(m.member_id)"=>"num","a.area_region"])
            ->join(["area"=>"a"],"m.member_province=a.area_name","LEFT")
            ->group("a.area_region")->select();