cname  |   role   |  person
Psyko    | director |  Thor
Psyko    |  admin   |  Carla
Sky Inc  | manager  |  Carla
Sky Inc  | director |  Celine

WITH RECURSIVE path_cte(cname, role, person, path, steps) AS (
    SELECT s1.cname, s1.role, s1.person, array[s1.person], 1
    FROM Company s1 JOIN Company s2 ON s1.cname = s2.cname
    WHERE s1.person = 'Thor'
        AND s1.person <> s2.person

UNION ALL

    SELECT c.cname, c.role, c.person, s.path, s.step+1
    FROM path_cte s JOIN Comapny c ON s.person = c.person
    WHERE c.person <> 'Celine'
        AND c.person <> any(s.path)
)
SELECT person, selskap, steg
FROM sti_cte
GROUP BY person, selskap, steg;