You don't need to, or want to - you'd be duplicating info, and it would be liable to error should a manager leave and be replaced for example.
Instead, use a JOIN when you SELECT the rows:
SELECT a.ID, a.Name, a.ManagerID, b.Name AS ManagerName FROM Managers a
JOIN Managers b ON a.ManagerID = b.ID