How to get category infomation from wordpress

getCategoryInfo.sql

SELECT a.term_id
     , a.name
     , a.slug
     , b.count
  FROM wp_terms a
       LEFT JOIN wp_term_taxonomy b
              ON a.term_id = b.term_id
 WHERE b.taxonomy = 'category';