1.FieldMapper.xml如下
<select id="getFieldMsg" resultMap="TableMap2">
SELECT
ff.id id,
ff.`name`,
fc.`name` classifyName,
type_name,
create_user_name
FROM
form_field ff
JOIN form_classify fc ON ff.classify_id = fc.id
WHERE
ff.id = #{fieldId}
</select>
<resultMap id="TableMap2" type="java.util.HashMap">
<id property="id" column="id"/>
<collection property="tableNames" column="id" select="com.hm.mapper.TableMapper.getNameByFieldId"/>
</resultMap>
2.TableMapper.xml如下
<select id="getNameByFieldId" resultType="java.lang.String">
SELECT
ft.name
FROM
form_table ft
JOIN form_table_field ftf ON ftf.table_id = ft.id
WHERE
ftf.field_id = #{fieldId}
</select>