The username is being used as the foreign key in the team_member_scores table
Ummm...no, it is not. At least not in your query.
And that's surely the problem.
Foreign keys are *NOT* automatically used in queries. Ever. They *MUST* be explicitly specified in the JOIN or they will be ignored. A foreign key DECLARATION in the table is only useful for preserving data integrity, not for queries.