I would like to use Sphinx and ThinkingSphinx to index the results of a nested set ancestry query, but I'm not entire sure how. The kind of query I need to do would be something like

SELECT id FROM taxa WHERE taxa.lft <= $target_taxon_lft AND taxa.rgt >= $target_taxon_rgt;

If I could somehow work the IDs from that query into a multi-value Sphinx attribute for each taxon, I would be golden. I just can't quite figure out how.