mybatis 递归查询

	<resultMap type="com.DictVO" id="treeMap">
        <result property="id" column="_id"/>
        <result property="code" column="_code"/>
        <result property="name" column="_name"/>
        <result property="parentCode" column="parent_code"/>
        <collection property="children"  ofType="com.DictEntity" column="_code" select="selectTree"/>
    </resultMap>

	<select id="treeList" resultMap="treeMap">
        select * from  sc_data_dict where parent_code is null
    </select>
    <select id="selectTree" parameterType="java.lang.String" resultMap="treeMap">
        select * from sc_data_dict where parent_code = #{_code}
    </select>

查询出来的数据

[
	{
	  "id": "ae4e2a2724fe6a7441a2e8847abfff40",
	  "code": "8ca0-c01f-b07e",
	  "name": "1",
	  "parentCode": null,
	  "children": [
	    {
	      "id": "d44fd9a80a6cd55221623ee3bc50ba0a",
	      "code": "248f-2d5a-1eec",
	      "name": "2",
	      "parentCode": "8ca0-c01f-b07e",
	      "children": [
	        {
	          "id": "d23c849c6eb92a9e033699e6a112eee9",
	          "code": "62d6-bac3-152c",
	          "name": "3",
	          "parentCode": "248f-2d5a-1eec",
	          "children": [
	            {
	              "id": "a17e76a46d90602d4599173417690617",
	              "code": "7233-02f2-3184",
	              "name": "4",
	              "parentCode": "62d6-bac3-152c",
	              "children": []
	            }
	          ]
	        }
	      ]
	    }
	  ]
	}
]