INSERT INTO user (id, content, author) SELECT id, id, null FROM test;

直接插入,Select查询出来的数据;