[{_id:"/players/c/cruzne02.shtml",url:"/players/c/cruzne02.shtml",name:"Nelson Cruz",image:"https://www.baseball-reference.com/req/202108020/images/headshots/f/fea2f131_mlbam.jpg",teams:[{name:"MIL",years:[2005,2006]}]},{_id:"/players/c/cruzne03.shtml",url:"/players/c/cruzne02333.shtml",name:"Nelson Cruz333",image:"https://www.baseball-reference.com/req/202108020/images/headshots/f/fea2f131_mlbam.jpg",teams:[{name:"BAL",years:[2006]},{name:"MIL",years:[2006]}]},{_id:"/players/c/cruzne022.shtml",url:"/players/c/cruzne022.shtml",name:"Nelson Cruz2",image:"https://www.baseball-reference.com/req/202108020/images/headshots/f/fea2f131_mlbam.jpg",teams:[{name:"BAL",years:[2015,2014,2016,2017,2018]},{name:"MIN",years:[2019,2020,2021]},{name:"TBR",years:[2021]}]}]

db.collection.aggregate([{"$match":{"teams":{$elemMatch:{$or:[{name:"MIL",years:{$in:[2005,2006]}},{name:"BAL",years:{$in:[2014]}}]}}}},{"$unwind":"$teams"},{"$unwind":"$teams.years"},{"$match":{"teams":{$in:[{name:"MIL",years:2005},{name:"MIL",years:2006},{name:"BAL",years:2014}]}}},{"$group":{"_id":{name:"$teams.name",year:"$teams.years"},teammates:{"$addToSet":"$$ROOT"}}}])