android sqlite transitive-closure-table example

I know that transitive-closure concept is used for storing tree structures data. This concept also used to retrieve hierarchical data in very efficient and quickly with minimum complex query.

can someone provides specific example in android using SQLite.