sql合并2个查询的数据UNION ALL

{{ time }}

如下

(SELECT a.id,a.username,a.nick_name,a.role_id FROM coding_admin AS a)
UNION ALL
(SELECT u.id,u.username,u.nick_name,u.role_id FROM coding_user AS u)