PHP Mongo 使用"find"方法的多"AND"

Question

我正在尝试使用"AND"条件，但它不匹配所有条件。我想只在所有条件都匹配的情况下获取结果。

My conditions are :-    
$and1 = array( '$and' => array(
array( "users.23315" => array( '$exists' => true ) ) ,                   
));   

$and2 = 
array( '$and' => array(
array('messages.message' => new MongoDBBSONRegex("2019"))));      

$where = array( '$and' => array( $and1, $and2) );

$client = new MongoDBClient(CONNECTION_STRING);
$db = $client->sample;
$collection = $client->sample->$db_name ;   
$result = $collection->find($where);
THE ISSUE IS NOT MATCHING ALL CONDITIONS. THE OUTPUT SHOULD CONDITION BOTH "2019" & "users.23315". But its not. Result is   
Array
(
[0] => Array
(       

[users] => Array
(
[23315] => 2022-06-28 13:07:54
)
[messages] => Array
(
[0] => Array
(

[message] => 2019 Test data                             
[user_id] => 23315
)
)            
)
[1] => Array
(                
[users] => Array
(
[23236] => 2021-12-16 12:49:17
[23315] => 2021-12-19 11:27:11
)
[messages] => Array
(
[0] => Array
(

[message] => Another row message
[direction] => 0
[user_id] => 23315
)
)             
)

You can see, the ARRAY[1] is matching only  "users.23315" exist true. The Message array is not having "2019". How can I force to include that ?

Answer 1

多个解决方案",

$where =   ['$and' => [
["users.$user_id" => ['$exists' => true]],
['messages.type' => 'whatsapp'],
['delete' => ['$ne' =>   1]],
]
];  

应用"And"条件的所有条件。要求结果