SELECT Name, TeamMemberRole, User.Email FROM OpportunityTeamMember

Use the below query if you know the UserId and Opportunity Id.


SELECT Name, TeamMemberRole, User.Email FROM OpportunityTeamMember WHERE OpportunityId = ‘OpportunityId’ AND UserId = ‘Id of the User’

Note:
Kindly make sure Team Selling is enabled.