What are the names and players of all the clubs?
select t1.name, t2.player_id from club as t1 join player as t2 on t1.club_id = t2.club_id