get value from get_post_meta then reuse it in another get_post_meta

Question

I am writing the following code, which I have updated since the original question so as to give the entire picture. I am a newbie, and the reason why I am not using the get_posts() function in combination with an add_filter() is simply because I couldn't get it to work so I simply went back to my comfort zone and wrote a select statement. Hopefully my novice-ness doesn't get me any downvotes :-)

    $search_term = $request->get('search');
            
    $terms = $wpdb->get_results(
        $wpdb->prepare("
            SELECT * 
            FROM {$wpdb->posts} 
            WHERE {$wpdb->posts}.post_type = 'rz_listing' 
            AND {$wpdb->posts}.post_status = 'publish' 
            AND {$wpdb->posts}.post_title LIKE '%%" . stripslashes( $wpdb->esc_like($search_term) ) . "%%'
            LIMIT $limit
        ") 
    );
    
    if( ! is_wp_error( $terms ) ) {

        if( ! empty( $terms ) ) {

            foreach( $terms as $term ) {
                        
                $rz_row = $term;
                
                // grab the icon Luke
                $placeicon = get_post_meta( $term->ID, 'rz_listing_type', true );
                $icon = get_post_meta( $placeicon, 'rz_icon', true );

            }
        }
    }

As you can see, I run the first query to get the meta_value that is used as the post_id for the subsequent query. This appears to be a very inefficient way to make two database calls, is there another way of doing it?