$cats = $wpdb->get_results(\'SELECT term_id, term_taxonomy_id, taxonomy, parent 
FROM wp_terms, wp_term_taxonomy 
WHERE term_id = term_taxonomy_id 
AND parent = 1
AND taxonomy = "category"\', ARRAY_A);