Need help transform a nested prisma query to drizzle

const invite = await prisma.invite.findUnique({
  where: {
    id: token
  },
  include: {
    invitedBy: {
      select: {
        title: true,
        firstName: true,
        lastName: true,
      }
    },
    course: {
      select: {
        name: true,
        settings: {
          select: {
            hostAlias: true,
            moderatorAlias: true,
            memberAlias: true
          }
        }
      }
    }
  }
});

const invite = await db
  .select({
    inviteExpiresAt: Invite.inviteExpiresAt,
    inviteAs: Invite.inviteAs,
    limit: Invite.limit,
    invitedBy: {
      title: User.title,
      firstName: User.firstName,
      lastName: User.lastName,
    },
    course: {
      id: Course.id,
      name: Course.name,
    },
    settings: {
      hostAlias: CourseSettings.hostAlias,
      moderatorAlias: CourseSettings.moderatorAlias,
      memberAlias: CourseSettings.memberAlias
    }
  })
  .from(Invite)
  .where(eq(Invite.id, token))
  .innerJoin(User, eq(Invite.invitedById, User.id))
  .innerJoin(Course, eq(Invite.courseId, Course.id))
  .innerJoin(CourseSettings, eq(Course.id, CourseSettings.courseId))