java 递归查询用户级所以下级（多层）用户

1.创建用户实体UserTreeVo

public class UserTreeVo {

    private String id;

    private List<UserTreeVo> children;

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public List<UserTreeVo> getChildren() {
        return children;
    }

    public void setChildren(List<UserTreeVo> children) {
        this.children = children;
    }
}

 2.查询该用户下的所有子孙用户 xml：

<resultMap type="com.ssish.saas.constant.db.vo.UserTreeVo" id="userIdTree">
		<id property="id" column="id"/>
		<association property="children" column="{id=id}" select="selectChildren"/>
	</resultMap>

	<select id="selectChillersByUserId" resultMap="userIdTree" >
		SELECT u.id