mongodb使用yii2

Question

数据是[{"_id":"60EAA56600B22A0D2B0000BB","createtime":1626019302,"info":{"bandate":0,"banstatus":0,"bundleID":"mj_android_aiyou","mOS":"other","mac":"0d443c042aee612111a87c98f42aafe9","username":"000368_58c0eb074d495268"},"realNameAuthSate":0}]

$query->select ( [] )->from ( 'UserDB' )->where(["info"=>["username"=>"000368_58c0eb074d495268"]]);
$rows = $query->all ($database);
查询的结果是空值，不知道如何写嵌套查询了

Answer 1

你可以使用MongoDB的$elemMatch操作符来实现嵌套查询，例如：
$query->select ( [] )->from ( 'UserDB' )->where(["info"=>["$elemMatch"=>["username"=>"000368_58c0eb074d495268"]]]);
$rows = $query->all ($database);