我的数据库中有两个聚合根实体，第一个是 Organization 与 Volunteer 以及 Moderators .
table：

create table organizations
(
    id   uuid primary key default uuid_generate_v4(),
    name varchar(255) not null,
    slug varchar(64)  not null unique
);

create table organization_moderators
(
    id              uuid primary key default uuid_generate_v4(),
    user_id         uuid not null,
    organization_id uuid not null,
    is_owner        boolean          default false,
    unique (user_id, organization_id),
    foreign key (user_id) references users (id) on delete cascade,
    foreign key (organization_id) references organizations (id) on delete cascade
);

create table organization_volunteers
(
    id              uuid primary key default uuid_generate_v4(),
    user_id         uuid not null,
    organization_id uuid not null,
    unique (user_id, organization_id),
    foreign key (user_id) references users (id) on delete cascade,
    foreign key (organization_id) references organizations (id) on delete cascade
);

实体：

@Value
@Table("organizations")
public class Organization {
    @Id
    @JsonIgnore
    UUID id;

    @Column("name")
    String name;

    @Column("slug")
    String slug;

    @MappedCollection(idColumn = "organization_id")
    Set<Moderator> moderators;

    @MappedCollection(idColumn = "organization_id")
    Set<Volunteer> volunteers;
}

@Value
@Table("organization_moderators")
public class Moderator {
    @Id
    @JsonIgnore
    UUID id;

    @Column("user_id")
    UUID userId;

    @Column("is_owner")
    boolean isOwner;
}

@Value
@Table("organization_volunteers")
public class Volunteer {
    @Id
    @JsonIgnore
    UUID id;

    @JsonIgnore
    @Column("user_id")
    UUID userId;
}

第二，用户聚合根。
表格：

create table users
(
    id            uuid primary key default uuid_generate_v4(),
    username      varchar(32)  not null unique,
    email_address varchar(255) not null unique,
    password      varchar(128) not null
);

实体：

@Value
@Table("users")
public class User {
    @Id
    UUID id;

    @Column("username")
    String username;

    @Column("email_address")
    String emailAddress;

    @Column("password")
    String password;
}

对于我想做的查询，我想获取一个组织及其志愿者，对于志愿者，我想包括users表中的用户名。如何使用spring数据jdbc实现这一点？我理解 User 不能是的聚合根的一部分 Organization ，但这仍然是我想一次性查询的数据。