Database

[{"_id":"62eca3abaeb0520009c0a1f4","Active":true,"name":"Sales",position:[{userid:"1xxxxx",orderby:0},{userid:"2xxxxx",orderby:1}]},{"_id":"62eca3b5aeb0520009c0a1f5","Active":true,"name":"Marketing",position:[{userid:"1xxxxx",orderby:2},{userid:"2xxxxx",orderby:1}]},{"_id":"62eca3bfaeb0520009c0a1f6","Active":true,"name":"CRM",position:[{userid:"1xxxxx",orderby:1},{userid:"2xxxxx",orderby:0}]}]

Query

db.collection.aggregate([{"$addFields":{"matchingUser":{"$arrayElemAt":[{"$filter":{"input":"$position","as":"user","cond":{"$eq":["$$user.userid","2xxxxx"]}}},0]}}},{"$sort":{"matchingUser.orderby":1}},{"$project":{"matchingUser":0}}])

Result