Код

public interface UserRepository extends ReactiveCrudRepository<User, Long> {

  @Query("select u.*,r.role_name as role from users u join roles r on u.role_id = r.id " +

      "where LOWER(u.username)=LOWER(:username)")

  Mono findByUsernameWithQuery(@Param("username") String username);

}