MongoDBデータベースを使用したオブジェクトIDの配列に関連するLaravelでデータを取得するための最良の方法 -- php フィールド と mongodb フィールド と laravel フィールド と eloquent フィールド と database フィールド 関連 問題

I have a table user data is as follow:

_id:ObjectId("mongodbid"), name:"acdfgf", skills:[ObjectId("skills id"),ObjectId("skill id 2")], created_at:date, updated_at:date 

Now I have to get the user data with skills data based on there id in one hit.

Thanks in advance...

Try this, Consider User is your model name

[you should have set this model to access the mongoDb if you are using hybrid with mySql or MariaDB]

User::whereRaw(['skills' => '2'])->get(); 

let me know if this didn't work.

Please find answer

$m = new MongoDBDriverManager();      $command = new MongoDBDriverCommand([         'aggregate' => 'mytestusers',         'pipeline' => [             ['$match' => ['name' => 'Pankaj Choudhary']],              ['$unwind'=>'$skills'],             ['$lookup' => array('from'=>'mytestskills','localField'=>'skills','foreignField'=>'_id','as'=>'sdfg')],             ['$unwind'=>'$sdfg'],              ['$group'=>array('_id'=>array('_id'=>'$_id','name'=>'$name','email'=>'$email'),'skills'=>array('$push'=>'$skills'),'sdfg'=>array('$push'=>'$sdfg'))],           ],         'cursor' => new stdClass,     ]);     $cursor = $m->executeCommand('targetjob-plus', $command);     $result = $cursor->toArray();