Mine

SELECT unit.*, equipment.description, equipment.id
FROM equipment
LEFT JOIN unit ON unit.equipment_id = equipment.id
WHERE equipment.user_id = 24