| | |
| | | <resultMap id="mallGoodsCategoryVoMap" type="cc.mrbird.febs.mall.vo.MallGoodsCategoryVo"> |
| | | <id column="id" property="id" /> |
| | | <result column="name" property="name" /> |
| | | <result column="image" property="image" /> |
| | | <result column="parent_id" property="parentId" /> |
| | | <collection property="child" ofType="cc.mrbird.febs.mall.vo.MallGoodsCategoryVo"> |
| | | <id column="child_id" property="id"/> |
| | | <result column="child_name" property="name" /> |
| | | <result column="image" property="image" /> |
| | | <result column="child_parent_id" property="parentId" /> |
| | | </collection> |
| | | </resultMap> |
| | |
| | | select |
| | | a.id, |
| | | a.name, |
| | | a.image, |
| | | a.parent_id, |
| | | b.id child_id, |
| | | b.name child_name, |
| | | b.image child_image, |
| | | b.parent_id child_parent_id |
| | | from mall_goods_category a |
| | | left join mall_goods_category b on a.id=b.parent_id |