Mark
SELECT tu.id userId, tu.avatar_url avatarUrl, tu.wx_nick_name wxNickName, tu.city city, (select dict_label from sys_dict_data where dict_type = ‘sys_user_sex‘ and dict_value = tu.sex) sex, if(1 = (select 1 from sys_user where phonenumber = tu.mobile limit 1), ‘代理‘, ‘用户‘) userDesc FROM t_wx_user tu
:)
原文:https://www.cnblogs.com/gotodsp/p/11096755.html