soql – Is there a possible way to search the name of a lookup fields using the search.query using apex in salesforce?

I had a lookup field on my object and I want to search the name of the lookup using search.query in apex, how can I do this?. In my debug, I am returning nothing. Below is my sample code.

String query = 'FIND \'Sonny McNeil\' IN ALL FIELDS RETURNING ASPHPP__ASPayment_Source__c (Id, Name,ASPHPP__PPContact__r.Name), Contact';
    System.debug('query '+query);

    List<List<sObject>> searchRecords = Search.Query(query);
    System.debug('searchRecords '+searchRecords);

    return searchRecords.get(0);

Read more here: Source link