The following steps solved it for me:
Go to the App Store Connect and select the team you don't have access to in Xcode.
Go to the "Users and Access".
Find yourself and click/tap your own name/user.
Change the "Preferred Currency" to anything else (and back, if desired).
Press "Save".
Logout/Login into Xcode and you should be able to see the team now in the list.
Topic:
Developer Tools & Services
SubTopic:
Xcode
Tags: