-- MSSQL --
WITH t AS
(
SELECT 1 seq, '0001' member_id, '박지성' favorite_player
UNION ALL SELECT  2, '0001', '손흥민'
UNION ALL SELECT  3, '0001', '이재성'
UNION ALL SELECT  4, '0001', '황희찬'
UNION ALL SELECT  5, '0001', '김승규'
UNION ALL SELECT  6, '0002', '박지성'
UNION ALL SELECT  7, '0002', '차범근'
UNION ALL SELECT  8, '0002', '김병지'
UNION ALL SELECT  9, '0003', '정우영'
UNION ALL SELECT 10, '0004', '정우영'
UNION ALL SELECT 11, '0004', '손흥민'
)
-- 1. PIVOT --
SELECT *
  FROM (SELECT member_id
             , favorite_player
             , FORMAT(ROW_NUMBER() OVER(PARTITION BY member_id ORDER BY seq), 'player00') gb
          FROM t
        ) a
 PIVOT (MIN(favorite_player) FOR gb IN ([player01], [player02], [player03], [player04], [player05])) a
;

-- 2. GROUP BY, MIN(CASE ) --
SELECT member_id
     , MIN(CASE rn WHEN 1 THEN favorite_player END) player01
     , MIN(CASE rn WHEN 2 THEN favorite_player END) player02
     , MIN(CASE rn WHEN 3 THEN favorite_player END) player03
     , MIN(CASE rn WHEN 4 THEN favorite_player END) player04
     , MIN(CASE rn WHEN 5 THEN favorite_player END) player05
  FROM (SELECT member_id
             , favorite_player
             , ROW_NUMBER() OVER(PARTITION BY member_id ORDER BY seq) rn
          FROM t
        ) a
 GROUP BY member_id
;