<selectid="getInfoById"resultType="java.util.Map">
select
ext.id as id,
info.produce_area as area,
ext.attribute_value as companyName
from product_info info
left join product_ext ext on info.id=ext.id
where info.id=#{id} and ext.attribute_name=#{name}
</select>
2. dao.java
@MapKey("id")
Map<Long,Map<String,String>>getInfoById(@Param("id") Long id,@Param("name") String name);