1.在没有设置默认值的情况下: SELECT userinfo.id, user_name, role, adm_regionid, region_name , create_time FROM userinfo LEFT JOIN region ON userinfo.adm_regionid = region.id 结果: watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQveHl3X2Jsb2c=/font/5a6L5L2T/fontsize/400/