直接上代码吧
public function t()
{
$cmd = [
'aggregate'=>'001_users_gemcases', //主表
'pipeline'=>[
[
'$lookup'=>[
'from' => '001_users', //关联表
'localField' => 'userId', //主表关联字段
'foreignField' => 'userId', //副表关联字段
'as'=>'joinData', //数据集名称
],
],
// [
// '$match'=>[], // 条件 聚合函数 等
// ],
[
'$sort'=>[
'Id' => -1, //按照某些字段排序 ,-1倒叙,1正序
],
],
// [
// '$skip'=>$skip, //跳过钱多少条 分页
// ],
[
'$limit'=>3,
],
],
'cursor' => new \stdClass,
'explain'=>false,
];
$command = new \MongoDB\Driver\Command($cmd);
$cursor = $this->manager->executeCommand('moba_game', $command)->toArray();
foreach ($cursor as $key => $val){
var_dump($val->joinData);
}
}