[{"Members":[{User:123,Rank:4},{User:456,Rank:1}]}]

db.collection.aggregate([{$match:{"Members.User":{$all:[123,456]}}},{$unwind:"$Members"},{$sort:{"Members.Rank":-1}},{$limit:1}])