Wordpress search - wpdb taxonomy term

wp_search_wpdb_taxonomy_term.php

<?php
$search_query = get_search_query(); 

$results = $wpdb->get_results("SELECT *
FROM $wpdb->terms AS wt
INNER JOIN $wpdb->term_taxonomy AS wtt ON wt.term_id=wtt.term_id
INNER JOIN $wpdb->term_relationships AS wtr ON wtr.term_taxonomy_id=wtt.term_taxonomy_id
LEFT JOIN $wpdb->posts wp ON wp.ID=wtr.object_id
WHERE taxonomy='$taxonomy' AND name LIKE '%%$search_query%%'
" );

echo '<pre>';
 print_r($results);
echo '</pre>';
?>