On gists

Insert into ... Select ... (cross join)

MySql MySql tricks

insert-select-join.sql Raw #

INSERT INTO `article_tag_lang` (article_tag_id, language_id, tag)
(
    SELECT i.id, l.id, i.tag
    FROM `language` AS l
    JOIN `article_tag` AS i
);