select username,(case typeid when 1 then '管理员' when 2 then '普通用户' else '未知' end) as typename from userman.users
select username, case usertype when 1 then '管理员' when 2 then '普通用户' else '未知' end 用户类型 from userman.users;