如何使用Spring Data JPA Join从不同的表中选择特定的列

@Entity
@Table(name = "user")
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;
    // 其他属性和对应的getter/setter方法
}

@Entity
@Table(name = "order")
public class Order {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String orderNumber;
    // 其他属性和对应的getter/setter方法
}

public interface UserRepository extends JpaRepository<User, Long> {
    @Query("SELECT u.name, o.orderNumber FROM User u JOIN Order o ON u.id = o.userId")
    List<Object[]> findUserAndOrder();
}

@Service
public class UserService {
    @Autowired
    private UserRepository userRepository;

    public List<Object[]> getUserAndOrder() {
        return userRepository.findUserAndOrder();
    }
}