Duplicate key name code example

Example: Duplicate key name 'fk_

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