select t1.regionId,t2.fullname as regionName,t1.approveLimit,t1.parentRegionId from config_ApproveLimit t1 inner join base_region t2 on t1.regionId = t2.id where t1.parentRegionId is null select t1.regionId,t2.fullname as regionName,t1.approveLimit from config_ApproveLimit t1 inner join base_region t2 on t1.regionId = t2.id where t1.parentRegionId = #{regionId} select * from config_ApproveLimit where regionId = #{regionId} update config_ApproveLimit set approveLimit = #{approveLimit} where regionId = #{regionId}