select al.name as "登录名", au.first_name as "显示名" ,ac.emailid as "邮箱" from aaalogin al 

left join aaauser au on al.user_id=au.user_id 

left join aaausercontactinfo auc on al.user_id=auc.user_id

left join aaacontactInfo ac on ac.contactinfo_id=auc.contactinfo_id