RT 上代码

        return $this->alias("a")
                    ->join("loan_co b","a.loan_co_a=b.id")
                    ->join("loan_co c","a.loan_co_b=c.id")
                    ->leftJoin("loan_hk d","a.id=d.lid")
                    ->where($where)
                    ->field("a.*,b.name as aname,c.name as bname,IFNULL(sum(d.hk_money),0) as pk")
                    ->group("a.id")
                    ->select();