如下
(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)
如下
(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)