How to add external data in select

this.drizzle.get({
  from: users,
  select: {
    id: users.id,
    username: users.username,
    name: users.name,
    surname: users.surname,
    email: users.email,
    job: users.job,
    phone: users.phone,
    avatar: users.avatar,
    last_seen: users.lastSeen,
    organization_id: users.organizationId,
    otp_enabled: users.otpEnabled,
    is_webauth: users.isWebauth,
  },
  page: query.page,
  perPage: query.per_page,
})
.where(GetUsersWhere(query))
.orderBy(desc(users.lastSeen))
.execute()
// My solution 
.then(async (users) => {
  return await Promise.all(
      users.map(
        async (user: { organization_id: number }) => {
          const jobs = await this.orgService.nestedUserJobs(user.organization_id);
          return {
            ...user,
            jobs
          }
   }))
});

{
  select: {
    jobs: (user) => await this.orgService.nestedUserJobs(user.organization_id)
  }
}