SELECT wpt.term_id, wpt.NAME, (SELECT name from wp_terms WHERE term_id = wptt.parent) AS parent FROM wp_terms wpt LEFT JOIN wp_term_taxonomy wptt ON wpt.term_id = wptt.term_id;
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.