Take a column value of comma delimited strings, compare it to another table ids to retrieve values belonging to each delimeted value, group them back into a comma delimited string, and store them in a column using GROUP_CONCAT

gistfile1.txt

SELECT v2m6q_npg_plants.name, GROUP_CONCAT(v2m6q_npg_plants_seasons.name) as seasons FROM v2m6q_npg_plants, v2m6q_npg_plants_seasons WHERE find_in_set(v2m6q_npg_plants_seasons.id, v2m6q_npg_plants.seasons)>0
GROUP BY name