//用户基础信息表
select Id as id, RealName as username, Mobile as phone, ReferralUserId as hidden_level, Areas as address,
ParentUserId as pid, CONCAT('0',REPLACE(ParentNav,',,',','))  as pid_path, MakerCode as user_code, HeadPhoto as avatar,
UserLevel as user_level, AuthFlag as real_status, MerchantType as is_merchant_maker, Remark as remark, CreateDate as create_time, UpdateDate as update_time
FROM Users

//用户实名信息表
select Id as id, Id as user_id, RealName as real_name, CertId as id_card, HandCertImage as id_card_hand, CertReverseImage as id_card_rear,
 CertFrontImage as id_card_front, AuthDate as create_time
FROM Users where CertId is not null and CertId<>'' and RealName<>''

//用户银行卡表
select Id as user_id, SettleBankName as bank_name, Mobile as bank_phone, SettleBankCardNo as bank_code, BankCardPositiveImage as bank_pic,
 SeoTitle as bank_open, SettleBankCardName as bank_card_name, AuthDate as create_time
FROM Users where SettleBankCardNo is not null and SettleBankName<>''

//用户收货地址表
select Id as id,
SUBSTRING_INDEX(Areas, ',', 1) AS province,
SUBSTRING_INDEX(SUBSTRING_INDEX(Areas, ',', -2), ',', 1) AS city,
SUBSTRING_INDEX(Areas, ',', -1) AS area,
address, Mobile as phone, RealName as consignee, IsDefault as is_default
 FROM UserAddress