SELECT `t` . `term_id` , `tt` . `parent` , `tt` . `count` , `tt` . `taxonomy` FROM `wp_terms` AS `t` INNER JOIN `wp_term_taxonomy` AS `tt` ON `t` . `term_id` = `tt` . `term_id` WHERE `tt` . `taxonomy` IN (?) ORDER BY `t` . `term_id` ASC 