[{username:"abcd",friends:[{name:"A",status:"active",code:"X1"},{name:"B",status:"inactive",code:"X2"},{name:"B",status:"active",code:"X3"}]},{username:"xyz",friends:[{name:"A",status:"active",code:"X1"},{name:"E",status:"inactive",code:"X2"},{name:"F",status:"active",code:"X3"}]},{username:"xyz",friends:[{name:"X",status:"active",code:"X1"},{name:"E",status:"inactive",code:"X2"},{name:"F",status:"active",code:"X3"}]}]

db.collection.find({"friends.name":"A"},{"username":1,"friends.$":1})