How define select, if bridge pair may have 3 players?
This is the MySQL solution (very similar to Leigh's Oracle solution):

SELECT Pair
 , GROUP_CONCAT(name SEPARATOR ' - ') Names
FROM Members m
JOIN Players p ON m.player_id = p.id
GROUP BY Pair;


Obligatory sqlfiddle which was modified from Leigh's illustration as well.*

* I give credit when I plagiarize!