title: Select all recursive value with one query SQLite
body: <p>i have some another case :</p>
  
  <p>first I created a table:</p>
  
  <pre><code> CREATE TABLE tree(
       id_tree integer PRIMARY KEY AUTOINCREMENT,
       id_boss TEXT,
       id_child TEXT,
       answ TEXT);
  </code></pre>
  
  <p>insert some values :</p>
  
  <pre><code> INSERT INTO tree(id_boss,id_child,answ) VALUES('1','8','T');
   INSERT INTO tree(id_boss,id_child,answ) VALUES('1',null,'F');
   INSERT INTO tree(id_boss,id_child,answ) VALUES('8','P1','T');
   INSERT INTO tree(id_boss,id_child,answ) VALUES('8','2','F');
   INSERT INTO tree(id_boss,id_child,answ) VALUES('2','P2','T');
   INSERT INTO tree(id_boss,id_child,answ) VALUES('2','P3','F');
  </code></pre>
  
  <p>and execute query:</p>
  
  <pre><code>  WITH RECURSIVE
    ancestors(id, answ) AS (
    VALUES('P3', 'T')
    UNION ALL
    SELECT tree.id_boss, tree.answ
    FROM tree JOIN ancestors ON tree.id_child = ancestors.id
    )
    SELECT id FROM ancestors WHERE answ = 'T';
  </code></pre>
  
  <p>the result is :</p>
  
  <pre><code>  P3
    1
  </code></pre>
  
  <p>that for <code>P3</code> , and i want to make list with all recursive value , so it will be like this :</p>
  
  <pre><code>   1 --- // P3
     1 --- // P1
     8 --- // P1
     2 --- // P2
     1 --- // P2
  </code></pre>