Database

db={"UserReview":[{_id:1,username:"John",content:"I liked the product",replies:[{username:"Andy",content:"I liked the product",status:"REJECTED"},{username:"Bob",content:"cool",status:"APPROVED"}]}]}

Query

db.UserReview.find({"replies.status":"APPROVED"},{content:1,username:1,replies:{"$elemMatch":{"status":"APPROVED"}}})

Result