You need to do some kind of scripting for this.

Read 1...n Active Application Services CI 

Loop 1 to N Application Services

    Look for Relationships in CMDB_REL_CI table {

          Where Parent or Child CI is -Application Service CI

          push Given Record in a Staging Table

                                                                        }

Once Data is populated in Staging table you can easily fetch the required Cis u are looking for

Regards

RP