Lateral joins

const campaignInvolvedInQuery = postgresDb
    .select({
        id: companyUserCampaignMappings.campaignId,
        campaignStatus: campaigns.status,
    })
    .from(companyUserCampaignMappings)
    .innerJoin(
        campaigns,
        eq(campaigns.id, companyUserCampaignMappings.campaignId)
    )
    .where(eq(companyUserCampaignMappings.companyUserId, companyUsers.id))
    .orderBy(desc(companyUserCampaignMappings.createdAt))
    .limit(1)
    .as("campaignInvolvedIn");
const userQuery = postgresDb
    .select({
        id: companyUsers.id,
        name: companyUsers.name,
        whatsappNumber: companyUserWhatsappChannelDetails.whatsappNumber,
        campaignInvolvedIn: campaignInvolvedInQuery.id,
    })
    .from(companyUsers)
    .innerJoin(
        companyUserWhatsappChannelDetails,
        eq(companyUsers.id, companyUserWhatsappChannelDetails.companyUserId)
    )
    .leftJoin(
        campaignInvolvedInQuery,
        notInArray(campaignInvolvedInQuery.campaignStatus, [
            CampaignStatus.ENDED,
            CampaignStatus.APPROVED,
            CampaignStatus.PENDING_APPROVAL,
        ])
    )
    .leftJoin(
        companyUserAssignedTags,
        eq(companyUserAssignedTags.companyUserId, companyUsers.id)
    )
    .where(
        and(eq(companyUsers.companyId, 1n), eq(companyUsers.isArchived, false))
    );

PostgresError: invalid reference to FROM-clause entry for table "company_users"