Having trouble writing my sql statement in drizzle. Want to join two variables

SELECT er.*, e1.name AS entity_one_name, e2.name AS entity_two_name
FROM "public"."relation" er
JOIN "public"."entity" e1 ON er."entityOneId" = e1.id
JOIN "public"."entity" e2 ON er."entityTwoId" = e2.id;

  const data = await db.select().from(entityRelations).where(or(
    eq(entityRelations.entityOne, id),
    eq(entityRelations.entityTwo, id)
  )).leftJoin(entities, or(
    eq(entities.id, entityRelations.entityOne),
    eq(entities.id, entityRelations.entityTwo)
  ));