Spring Data native query with pagination

@Query(value = "WITH RECURSIVE depart_tree AS " +
            "(" +
            "SELECT d1.* FROM departments d1 WHERE d1.id = :departmentId " +
            "UNION " +
            "SELECT d2.* FROM departments d2 JOIN depart_tree dt1 ON dt1.id = d2.parent_id" +
            ") " +
            "SELECT u.* FROM depart_tree dt2 JOIN users u ON u.department_id = dt2.id " +
            "WHERE (upper(u.username) like concat('%',upper(:filter),'%') OR " +
            "upper(u.full_name) like concat('%',upper(:filter),'%')) AND u.deleted = false",
            nativeQuery = true)
    Page<User> findAllByDepartmentWithFilter(Pageable pageable, @Param("departmentId") UUID departmentId, @Param("filter") String filter);

Hibernate: WITH RECURSIVE depart_tree AS (SELECT d1.* FROM departments d1 WHERE d1.id = ? UNION SELECT d2.* FROM departments d2 JOIN depart_tree dt1 ON dt1.id = d2.parent_id) SELECT u.* FROM depart_tree dt2 JOIN users u ON u.department_id = dt2.id WHERE (upper(u.username) like concat('%',upper(?),'%') OR upper(u.full_name) like concat('%',upper(?),'%')) AND u.deleted = false order by d1.fullName asc limit ?