I don't understand what you're asking, so I'll just give you some related information:
The table cmdb_rel_ci is where CMDB relationships (like runs::runs on, etc.) are stored. So if you want to find all of the CIs for an Application Service, for example, you need to find all rows in this table where your specific Application Service is the "parent" in the appropriate relationships to first find all of the first-level children of that Application Service. Then you need to go through the same process with each one of those first-level children, getting all of the rows where each of those is the "parent" in the appropriate relationships, etc. Until you have all of the "leaf node" child CIs associated with that Application Service.
Frank
Please mark this reply as Helpful/Correct.
