select * from
(
select u.*,
r.FullName as RoleFullName ,
d.FullName as DicFullName
from base_user u
left join base_roles r on u.roleid = r.roleid
left join base_dics d on r.Category = d.DicsId
where 1=1
order by u.Createdate desc
) a
limit 0,10;