public function getDataSplit() { $limit = 10; $gameRecord = $this->getlink('game_record'); $where = ['share_wechat_id' => 'oiyNFuOoe4NMhX-Hvi5OmyR0yltg']; $gameRecord->setWhere($where); $helperRs = $this->getlink('game_record')->get(); //php计算总得分 $arrHelper = []; $arrWechatId = []; foreach ($helperRs as $v) { $arrWechatId[$v['wechat_id']] = $v['wechat_id']; //记录下助攻者的id, 用于查询用户信息 nickname, image... if (!empty($arrHelper[$v['wechat_id']])) { $arrHelper[$v['wechat_id']]['score'] += $v['score']; } else { $arrHelper[$v['wechat_id']] = $v; } } //附加信息, 头像, 昵称 $gameUsers = $this->getlink('game_users'); $gameUsers->setWhereIn('wechat_id', $arrWechatId); $arrExtra = $gameUsers->get('wechat_id'); //排序 //usort($arrHelper, array($this, 'mysort')); $arrHelper = Fun::sort2DArray($arrHelper, 'score', '1'); $arrHelper = array_slice($arrHelper, 0, $limit); foreach ($arrHelper as &$v) { $v['wechat_name'] = $arrExtra[$v['wechat_id']]['wechat_name']; $v['wechat_image'] = $arrExtra[$v['wechat_id']]['wechat_image']; } return $arrHelper; }