recursive query

Is it possible to make a recursive query?
It’s about supervision levels, to select employees the works under supervision of certain person and inturn select employees that work under supervision of first query …etc , till i reach the last level.