whereIn('uid', [$uid, $toUid]); $model = $model->whereIn('to_uid', [$uid, $toUid]); $model = $model->order('id DESC'); $model = $model->page($page, $limit); // TODO: 循环 SQL return $model->select()->each(function ($item) { $userInfo = StoreService::where('uid', $item['uid'])->field('nickname,avatar')->find(); if (!$userInfo) { $userInfo = User::getUserInfo($item['uid'], 'nickname,avatar'); } if ($userInfo) { $item['nickname'] = $userInfo['nickname']; $item['avatar'] = $userInfo['avatar']; } if ($item['msn_type'] == self::MSN_TYPE_GOODS && $item['msn']) { $item['productInfo'] = StoreProduct::validWhere()->where('id', $item['msn'])->find(); } else { $item['productInfo'] = []; } $item['orderInfo'] = []; if ($item['msn_type'] == self::MSN_TYPE_ORDER && $item['msn']) { $order = StoreOrder::getUserOrderDetail($item['uid'], $item['msn']); if ($order) { $order = StoreOrder::tidyOrder($order->toArray(), true, true); $order['add_time_y'] = date('Y-m-d', $order['add_time']); $order['add_time_h'] = date('H:i:s', $order['add_time']); $item['orderInfo'] = $order; } } $item['msn_type'] = (int)$item['msn_type']; }); } }