"Duplicate key name foreign key code example

Example: Duplicate key name 'fk_

SELECT U.*, UP.name
FROM units U
LEFT JOIN units UP ON U.parent_id = UP.id