Database

db={"PetTable":[{"_id":ObjectId("6013859ba0c3120034d08bfa"),"bdTable":"zzzz","status":ObjectId("5e7bb9e8f99a071990f62506")},{"_id":ObjectId("6013859ba0c3120034d08bfb"),"bdTable":"aaaa","status":ObjectId("6013859ba0c3120034d08bfc")}],"Status":[{"_id":ObjectId("5e7bb9e8f99a071990f62506"),statusCode:5,petId:ObjectId("621d259b21d9a0dfecd02e4d")},{"_id":ObjectId("6013859ba0c3120034d08bfc"),statusCode:5,petId:ObjectId("621d259b21d9a0dfecd02e4f")}]}

Query

db.PetTable.aggregate([{$match:{bdTable:"zzzz"}},{$lookup:{from:"Status",let:{status_id:"$status"},pipeline:[{$match:{$expr:{$and:[{$eq:[5,"$statusCode"]},{$eq:["$_id","$$status_id"]}]}}}],as:"status"}},{$match:{$expr:{$gt:[{$size:"$status"},0]}}}])

Result