left join生成的语句是 LEFT JOIN `fa_evaluate_invite` `evaluateinvte` ON `evaluate_organize`.`eo_id`=`evaluateinvte`.`ei_evaluate_id` 如果 我还需要在on后面加条件要怎么写 比如 LEFT JOIN `fa_evaluate_invite` `evaluateinvte` ON `evaluate_organize`.`eo_id`=`evaluateinvte`.`ei_evaluate_id` and `evaluateinvte`.`ei_ei_id` = 163

如果你需要在 `LEFT JOIN` 语句后面添加条件，你可以在 `ON` 子句中添加条件，例如：

LEFT JOIN `fa_evaluate_invite` `evaluateinvte` ON `evaluate_organize`.`eo_id`=`evaluateinvte`.`ei_evaluate_id` AND `evaluateinvte`.`ei_ei_id` = 163

这将会在 `LEFT JOIN` 语句中添加另一个条件，只有在 `evaluateinvte.ei_ei_id` 等于 163 时才会进行连接。

相关问题

LEFT JOIN `fa_evaluate_invite` `evaluateinvte` ON `evaluate_organize`.`eo_id`=`evaluateinvte`.`ei_evaluate_id` AND `evaluateinvte`.`ei_ei_id` = 163 用hasone 怎么写

使用 `hasOne` 可以这样写：

class EvaluateOrganize extends Model
{
    public function evaluateInvte()
    {
        return $this->hasOne(EvaluateInvite::class, 'ei_evaluate_id')->where('ei_ei_id', 163);
    }
}

这样会定义一个名为 `evaluateInvte` 的关联关系，表示一个 `EvaluateOrganize` 模型对象拥有一个 `EvaluateInvite` 模型对象，且在关联查询时会自动关联上 `ei_evaluate_id` 和 `ei_ei_id = 163` 的条件。可以通过以下方式获取关联的 `EvaluateInvite` 模型对象：

$organize = EvaluateOrganize::find(1);
$invte = $organize->evaluateInvte;

SELECT orders.id,orders.user_id,orders.cityarea_id,orders.batchcode,orders.status, orders.pay_status,orders.real_pay,orders.total,orders.money,orders.pay_type, orders.premium,orders.createtime,orders.paytime,orders.confirmtime, orders.is_evaluate,orders.pay_method,orders.exp_user_id, orders.return_score, orders.is_change,orders.reward_money,orders.isvalid,orders.after_sale_status,orders.remark, orders.use_coupon_detail,orders.block_chain_price, users.name,users.weixin_name,users.weixin_fromuser, users.phone,wcoe.diy_area_name ,writes.ActivityStatus,writes.NewMoney,records.Commission,records.ReturnRadio from wsy_o2o.weixin_cityarea_orders orders left join wsy_o2o.weixin_cityarea_supply supply on orders.cityarea_id = supply.id left join wsy_o2o.weixin_cityarea_payonline_orders wcco on orders.batchcode=wcco.batchcode left join wsy_user.weixin_users users on users.id = orders.user_id LEFT JOIN wsy_o2o.weixin_cityarea_orders_extend wcoe ON orders.batchcode = wcoe.batchcode LEFT JOIN wsy_dream.ShopWrite writes on orders.batchcode = writes.Batchcode LEFT JOIN wsy_o2o.weixin_cityarea_supply_commissons_record records ON orders.cityarea_id = records.SupplyId and records.CreateTime < orders.createtime ORDER BY records.CreateTime DESC LIMIT 1 WHERE orders.types=3 and orders.customer_id = 41 AND orders.isvalid=true GROUP BY orders.batchcode ORDER BY orders.id DESC limit 0,20; 以上代码报错，怎么解决

根据您提供的查询代码，有几个问题需要解决：

1. `LIMIT` 和 `ORDER BY` 语句的顺序错误。在 `ORDER BY` 之前应该是 `WHERE` 语句，然后是 `GROUP BY`，最后是 `ORDER BY` 和 `LIMIT`。请将这两个语句调整到正确的位置。

2. `LEFT JOIN` 和 `JOIN` 语句之间缺少逗号。请在第一个 `LEFT JOIN` 语句和第二个 `LEFT JOIN` 语句之间添加逗号。

修改后的代码如下：

SELECT orders.id, orders.user_id, orders.cityarea_id, orders.batchcode, orders.status, 
orders.pay_status, orders.real_pay, orders.total, orders.money, orders.pay_type, 
orders.premium, orders.createtime, orders.paytime, orders.confirmtime, 
orders.is_evaluate, orders.pay_method, orders.exp_user_id, orders.return_score,
orders.is_change, orders.reward_money, orders.isvalid, orders.after_sale_status, orders.remark,
orders.use_coupon_detail, orders.block_chain_price, users.name, users.weixin_name, users.weixin_fromuser,
users.phone, wcoe.diy_area_name , writes.ActivityStatus, writes.NewMoney, records.Commission, records.ReturnRadio
FROM wsy_o2o.weixin_cityarea_orders orders 
LEFT JOIN wsy_o2o.weixin_cityarea_supply supply ON orders.cityarea_id = supply.id 
LEFT JOIN wsy_o2o.weixin_cityarea_payonline_orders wcco ON orders.batchcode = wcco.batchcode 
LEFT JOIN wsy_user.weixin_users users ON users.id = orders.user_id 
LEFT JOIN wsy_o2o.weixin_cityarea_orders_extend wcoe ON orders.batchcode = wcoe.batchcode
LEFT JOIN wsy_dream.ShopWrite writes ON orders.batchcode = writes.Batchcode 
LEFT JOIN wsy_o2o.weixin_cityarea_supply_commissons_record records ON orders.cityarea_id = records.SupplyId AND records.CreateTime < orders.createtime 
WHERE orders.types = 3 AND orders.customer_id = 41 AND orders.isvalid = true 
GROUP BY orders.batchcode 
ORDER BY records.CreateTime DESC 
LIMIT 1 OFFSET 0;

请注意，上述修改的代码仅修复了语法错误。如果仍然存在问题，可能需要进一步检查表和列名的正确性以及其他约束条件。