你可以用 union all ```
select *, 'table1' as table_name from table1
union all
select *, 'table2' as table_name from table2

确保两个表的列数相同，如果没有，则指定所需的列名，如select col1、col2。。。
如果您想创建一个新表，那么

create table new_table
select *, 'table1' as table_name from table1
union all
select *, 'table2' as table_name from table2

创建表。。。选择语法

(
SELECT
    `a`.`id` AS `id`,
    `a`.`name` AS `name`,
    'table1' AS `TABLE_NAME`
FROM
   `table1` `a`
ORDER BY
    `a`.`role`
LIMIT 5
)
UNION
(
SELECT
    `b`.`id` AS `id`,
    `b`.`student_name` AS `student_name`,
    'tavle2' AS `TABLE_NAME`
FROM
    `table2` `b`
ORDER BY
    `b`.`student_role`
LIMIT 5
)