INSERT INTO theme_name (theme_id, lang, value) SELECT id, 'en', name_en FROM theme;
Note: it's possible to add conditions.