Database
db={"totalpoints":[{"_id":{"playerId":"113069","tournamentId":"197831"},"playerName":"xyz","pointsTotal":0,"__v":0}],"team":[{"_id":{"teamName":"BILALATI6449","tournamentId":"197831"},"tournamentName":"Amanora Cricket Championship 2021","player1":{"playerId":"113069","tournamentId":"197831"},"_v":0}]}
Query
db.team.aggregate([{"$match":{"_id.teamName":"BILALATI6449","_id.tournamentId":"197831"}},{"$lookup":{"from":"totalpoints","localField":"player1.playerId","foreignField":"_id.playerId","as":"player1"}}])