Query/select statement of column via sql`` for extras field

const lessonWithComments = await db.query.Lesson.findFirst({
  where: eq(Lesson.id, lessonId),
  with: {
    comments: {
      with: {
        reactions: true,
        user: {
          columns: {
            id: true,
            title: true,
            firstName: true,
            lastName: true,
            image: true
          },
          extras: {
            memberKind: sql`
              SELECT ${MemberOnCourse.memberKind}
              FROM ${MemberOnCourse}
              WHERE ${MemberOnCourse.userId} = ${User.id}
            `.as("memberKind")
          }
        }
      }
    }
  },
  orderBy: (Comment, { asc }) => [asc(Comment.createdAt)]
});