Join parent with children and children with grandchildren in a single query

I am learning Spring Data JPA. I want to implement this query in it:

Spring Data JPA / Hibernate: Join Parent with Children and Children with Grandchildren in a single query

I am learning spring data jpa. I want to implement this query in it:-