最近写项目，发现还是少用tp的haswhere，及数组方式定义嵌套预载入【关联查询等】

这是推荐的用法，快速好查，后期查询省事

$list = Db::table($this->table)
        ->alias('basic_order')
        ->field($select)
        ->join("$chargeModel->table charge_order", "basic_order.sale_order = charge_order.sale_order AND charge_order.status > 0 AND charge_order.pay_status > 0", 'LEFT')
        ->where($where)
        ->where($whereMore)
        ->order($order)
        ->paginate($limit);

不推荐因为这样 basicOrder的条件就不好传了~，大家有别的的方法么

$list = $this->model::hasWhere("chargeOrder",function ($query) use ($order){
            $query->where("ChargeOrder.sale_order","<>",0);
        })
            ->with([
                'chargeOrder'=>['basicOrder','power']
            ])
            ->where($map)
            // ->where($where)
            ->group("SaleOrder.id")
            ->order("SaleOrder.id DESC")
            ->paginate($limit);