laravel下载数据关联模型数据多超出mysql占位数？

Question

1、查询用户列表，初始换关联订单表，但是用户太多，导致mysql占位符过了，报mysql错误。

2、User::with('order')->get()

报错：General error: 1390 Prepared statement contains too many placeholders

select * from order where user_id in (xxx,xxx , ......)
因为后续需要循环处理订单相关联的数据。
foreach ($user as $v) {

$order_list = $v->order;
$temp_test = [];
if (count($order_list) > 0) {
    foreach ($order_list as $ov) {
        $temp_test[] = $ov->order_id;
    }
}
$data = [
    'user_id' => $v->user_id,
    'order_id' => implod(',', $temp_test)
];
echo $this->downExcel($data);

}

Answer 1

使用chunk即可。