$cardNoBegin = 1;
$cardNoEnd = 10000;
$where['number'] = array('between' , [$cardNoBegin , $cardNoEnd]);
$list = VipCardModel::where($where)->field('id,number,issue_uid,rank')->select();foreach($list as &$value){ // 只想到foreach來處理，但是這樣很奇怪，覺得這樣處理不對。
$value['name'] = UserModel::where(array('id' => $value['issue_uid']))->value('name');
}
1 回答
holdtom
TA貢獻1805條經驗 獲得超10個贊
shmiyle同學已經正確的回答了這個問題，我在他的基礎上優化一下,提升一點效率
$where['number'] = array('between' , [$cardNoBegin , $cardNoEnd]);
$list = VipCardModel::where($where)->field('id,number,issue_uid,rank')->select();
$issueUidList = array_unique((array_column($list, 'issue_uid')));unset($list);//查詢用戶信息$userList = UserModel::where(array('id' => array('in', $issueUidList)))->value('name');
$userInfoList=array_column($userList,'name','id');foreach($list as $key => $value){
$list[$key]['name'] = $userInfoList[$value['issue_uid']] ?? '';
}添加回答
舉報
0/150
提交
取消