select
ua.id id,
ub.umc_login_name umcLoginName,
ua.app_cluster_company appClusterCompany,
ua.app_cluster_user appClusterUser,
ua.name clusterName,
ua.app_cluster_login_name appClusterLoginName,
ua.create_time createTimeV,
ua.create_user_id createUserId
from umc_user_base ub
right join (select distinct(ac.id),band.*, ac.name
from umc_user_banding band
left join umc_app_cluster ac on band.app_cluster_id = ac.id)
ua on ub.id = ua.umc_user_id
where ub.id = '1'