SELECT Manager.*, COUNT( * ) AS level FROM managers AS Manager, managers AS Manager2 WHERE Manager.lft BETWEEN Manager2.lft AND Manager2.rght GROUP BY Manager.lft