multiple joins of same table in one query?

return await db
  .select({
    ...getTableColumns(interests),
    user: getTableColumns(users),
    referral: getTableColumns(referrals),
    referrer: getTableColumns(users),
  })
  .from(interests)
  .innerJoin(users, eq(interests.userId, users.id))
  .leftJoin(referrals, eq(interests.referralId, referrals.id))
  .leftJoin(users, eq(referrals.referrer, users.id));