BEGIN
RETURN query
WITH RECURSIVE R AS
(SELECT id
FROM accounts.groups WHERE id=(_id)
UNION ALL
  SELECT accounts.groups.id
  FROM accounts.groups
     JOIN R
         ON accounts.groups.parent_id = r.id
)
SELECT *FROM R;
END;

select * from table where hierarchy like '1.%'

CREATE OR REPLACE FUNCTION accounts.without_recursive(_id uuid)  RETURNS table (id uuid, parent_id uuid, name character varying(64))AS
$BODY$
DECLARE
r uuid;
BEGIN
--return query
FOR r in SELECT id, parent_id, name FROM accounts.groups WHERE id = _id
LOOP
 return query
   select ag.id, ag.parent_id, ag.name from accounts.groups as ag join r ON ag.id = r.parent_id;
   RETURN NEXT;
END LOOP;
RETURN;
END;
$BODY$
LANGUAGE 'plpgsql' STABLE STRICT

CREATE OR REPLACE FUNCTION accounts.without_recursive(_id uuid)  RETURNS table (id uuid, parent_id uuid, name character varying(64))AS
$BODY$
DECLARE
row_ record;
BEGIN
RETURN query
--возвращаем первую ветку дерева
SELECT us.id, us.parent_id, us.name FROM accounts.groups us WHERE us.id = _id;
--возвращаем детей
FOR row_ IN SELECT us.id, us.parent_id, us.name FROM accounts.groups us WHERE us.id = _id
LOOP
RETURN query
SELECT r.id, r.parent_id, r.name FROM accounts.groups AS r WHERE r.parent_id =row_.id;
  RETURN NEXT;
END LOOP;
RETURN;
END;
$BODY$
LANGUAGE plpgsql VOLATILE