Issue description

relationLoadStrategy query: ER_NONUNIQ_TABLE during recursive call

Expected Behavior

When using a ManyToOne from an Entity to the same Entity, TypeORM should use an alias when joining the table

Actual Behavior

The table "Folder" is called twice with the same alias :

SELECT Folder.id AS Folder_id,
Folder.familyLinkId AS Folder_familyLinkId,
Folder.id AS Folder_id,
Folder.familyLinkId AS Folder_familyLinkId
FROM folder Folder
INNER JOIN folder Folder ON Folder.familyLinkId = Folder.id
WHERE Folder.id IN (7486)

Steps to reproduce

@entity()
export class Folder {

@PrimaryGeneratedColumn()
id: number;

@OneToMany((type) => Folder, (folder) => folder.family_link)
@JoinTable()
linked_folders: Folder[];

@ManyToOne((type) => Folder, (folder) => folder.linked_folders, {
	nullable: true,
})
family_link: Folder;

}

folders = await folderRepository.find({
relationLoadStrategy: "query",
where: { id: In(foldersID) },
relations: {
family_link: true
}
})

My Environment

Additional Context

IMHO (I'm really not a javascript dev 😅), I think the problem is in FindOptionsUtils.ts, in applyRelationsRecursively.
In case of relationLoadStrategy query, it use "relation" but not "relationAlias"

Thank you all for the good work, keep up with it !

Relevant Database Driver(s)

• aurora-mysql
• aurora-postgres
• better-sqlite3
• cockroachdb
• cordova
• expo
• mongodb
• mysql
• nativescript
• oracle
• postgres
• react-native
• sap
• spanner
• sqlite
• sqlite-abstract
• sqljs
• sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

Yes, I have the time, but I don't know how to start. I would need guidance.