How to save the result of a query to a table?

Question

MySQL

How to save the result of a query to a table?
I write like this

INSERT INTO `test`(`id`, `ru`, `en`, `zh`) 
VALUES (ru.id, ru.name, en.name, zh.name) 
SELECT ru.id, ru.name, en.name, zh.name
FROM ru
LEFT JOIN en ON ru.id = en.id
LEFT JOIN zh ON ru.id = zh.id

Syntax error

Answer 1

INSERT INTO `test`(`id`, `ru`, `en`, `zh`) 
SELECT ru.id, ru.name, en.name, zh.name
FROM ru
LEFT JOIN en ON ru.id = en.id
LEFT JOIN zh ON ru.id = zh.id