Database

[{"_id":ObjectId("608dd1a2abf9c97d8d771c41"),"competition":{"area":{"id":2072,"name":"England"},"code":"PL","id":2021,"lastUpdated":"2021-04-17T02:20:14Z","name":"Premier League","plan":"TIER_ONE"},"filters":{},"season":{"currentMatchday":34,"endDate":"2021-05-23","id":619,"startDate":"2020-09-12","winner":"None"},"standings":[{"group":"None","stage":"REGULAR_SEASON","table":[{"draw":5,"form":"W,W,L,W,W","goalDifference":47,"goalsAgainst":24,"goalsFor":71,"lost":4,"playedGames":34,"points":80,"position":1,"team":{"crestUrl":"https://crests.football-data.org/65.svg","id":65,"name":"Manchester City FC"},"won":25}]}]},{"_id":ObjectId("608dd1a2abf9c97d8d771c42"),"competition":{"area":{"id":2072,"name":"England"},"code":"PL","id":2021,"lastUpdated":"2021-04-17T02:20:14Z","name":"Premier League","plan":"TIER_ONE"},"filters":{},"season":{"currentMatchday":34,"endDate":"2021-05-23","id":619,"startDate":"2020-09-12","winner":"None"},"standings":[{"group":"None","stage":"REGULAR_SEASON","table":[{"draw":5,"form":"W,W,L,W,W","goalDifference":47,"goalsAgainst":24,"goalsFor":71,"lost":4,"playedGames":34,"points":80,"position":1,"team":{"crestUrl":"https://crests.football-data.org/65.svg","id":65,"name":"Real Madrid"},"won":25}]}]}]

Query

db.collection.find({"standings.table.team.name":"Manchester City FC"})

Result