from(CustomDebtChange::tableName()); $query->where(['capitalType' => 40]); foreach ($query->batch() as $batch) { foreach ($batch as $change) { $changeId = $change['id']; $relateId = $change['relateId'] ?? 0; $refund = RefundOrderClass::getById($relateId, true); $relateOrderSn = $refund->relateOrderSn ?? ''; if (empty($relateOrderSn)) { continue; } echo $changeId.' '.$relateId.' '.$relateOrderSn;die; $order = OrderClass::getByCondition(['orderSn' => $relateOrderSn], true); if ($order->payStatus == 1) { $payTime = $order->payTime; CustomDebtChangeClass::updateById($changeId, ['payTime' => $payTime]); } } } } }