[{"_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]},{"name":"TEX","years":[2006,2007,2008,2009,2010,2011,2012,2013]},{"name":"BAL","years":[2014]},{"name":"SEA","years":[2015,2016,2017,2018]},{"name":"MIN","years":[2019,2020,2021]},{"name":"TBR","years":[2021]}]},{"_id":"/players/d/donaljo02.shtml","url":"/players/d/donaljo02.shtml","name":"Josh Donaldson","image":"https://www.baseball-reference.com/req/202108020/images/headshots/3/3af4cc98_mlbam.jpg","teams":[{"name":"OAK","years":[2010,2012,2013,2014]},{"name":"TOR","years":[2015,2016,2017,2018]},{"name":"CLE","years":[2018]},{"name":"ATL","years":[2019]},{"name":"MIN","years":[2020,2021]}]}]

db.collection.aggregate([{$unwind:"$teams"},{$unwind:"$teams.years"},{$group:{_id:{team:"$teams.name",year:"$teams.years",},results:{$push:{"name":"$name","id":"$_id"}}}},{$match:{"results.id":"/players/c/cruzne02.shtml"}}])