如果要在后端MYSQL查询中显示分类名称和帖子标题，可以使用以下查询：-

SELECT   p.ID,taxonomy,post_title,post_status,name
FROM    wp_posts p, wp_term_relationships rel, wp_terms t, wp_term_taxonomy 
te
where  
   p.ID = rel.object_id
  AND t.term_id=te.term_id
  AND t.term_id=rel.term_taxonomy_id
  AND taxonomy in (\'taxonomy\')
  AND Post_type=\'post\'
  and name=\'name of taxonomy\'