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