Player to roster

INSERT INTO fhc_hockey_team_roster(season_id, league_id, team_id, player_id, player_photo)
SELECT
  2 AS season,
  1 AS league,
  1 AS team,
  hp.player_id,
  concat('S2_P',hp.player_id,'_',hp.player_alias,'.jpg') AS photo
FROM fhc_hockey_player hp;