String word = (String)map.get("word");
        String status = (String)map.get("status");
        Integer deptId = (int)map.get("deptId");

        QueryWrapper query = QueryWrapper.create();
        query.and(SYS_USER.DEPT_ID.eq(deptId).when(ObjUtil.isNotNull(deptId))
            .or(SYS_USER.DEPT_ID.in(
                select(SYS_DEPT.ID).from(SYS_DEPT)
                    .where(new StringQueryCondition("FIND_IN_SET (?, " + SYS_DEPT.ANCESTORS.getName() + ")", deptId).when(ObjUtil.isNotNull(deptId)))
                )
            )
        )
        .and(SYS_USER.STATUS.eq(status).when(StrChecker.isNotBlank(status)))
        .and(SYS_USER.ACCOUNT.like(word).when(StrChecker.isNotBlank(word))
            .or(SYS_USER.NICKNAME.like(word).when(StrChecker.isNotBlank(word)))
            .or(SYS_USER.EMAIL.like(word).when(StrChecker.isNotBlank(word)))
            .or(SYS_USER.PHONE.like(word).when(StrChecker.isNotBlank(word)))
        );

        this.userMapper.selectListByQuery(query)

SELECT * 
FROM `sys_user` 
WHERE `dept_id` = ?  OR `dept_id` IN ( SELECT `id` FROM `sys_dept` WHERE FIND_IN_SET (?, ancestors ) AND `del` = ? ) 
	AND `status` = ? 
	AND ( `account` LIKE ? OR `nickname` LIKE ? OR `email` LIKE ? OR `phone` LIKE ? ) 
	AND `del` = ? 

SELECT * 
FROM `sys_user` 
WHERE ( `dept_id` = ?  OR `dept_id` IN ( SELECT `id` FROM `sys_dept` WHERE FIND_IN_SET (?, ancestors ) AND `del` = ? ) )
	AND `status` = ? 
	AND ( `account` LIKE ? OR `nickname` LIKE ? OR `email` LIKE ? OR `phone` LIKE ? ) 
	AND `del` = ?