[{"_id":"47bb","email":"myemail@gmail.com","orders":[{"orderNumber":"","products":[{"brand":"Brand 1","processing":{"status":"pending"}}],"updated":{"$date":{"$numberLong":"1673031718883"}}},{"orderNumber":"","products":[{"brand":"Brand 2","processing":{"status":"pending"}}],"updated":{"$date":{"$numberLong":"1673031718883"}}},{"orderNumber":"","products":[{"brand":"Brand 3","processing":{"status":"processing"}}],"updated":{"$date":{"$numberLong":"1673031718883"}}}],"privilege":{"admin":false},"isVerified":{"email":"true"}}]

db.collection.aggregate([{"$match":{"orders.products.processing.status":"pending"}},{"$project":{"email":1,"isVerified":1,"privilege":1,"orders":{"$filter":{"input":{"$map":{"input":"$orders","as":"order","in":{"orderNumber":"$$order.orderNumber","products":{"$filter":{"input":"$$order.products","cond":{"$eq":["$$this.processing.status","pending"]}}}}}},"as":"mapped_array","cond":{"$ne":["$$mapped_array.products",[]]}},}}}])