@Query("SELECT u FROM User u LEFT JOIN FETCH u.roles WHERE u.email = :email")
Optional<User> findByEmailWithRoles(@Param("email") String email);

I like to use mysql but this query blows my mind. After spending 3 HOURS community say me this is not sql — this is something called JPQL.

But i want to use sql. Is anyone solve my issue