What’s wrong with my wp database query?

Any reason why you can’t use WordPress API?

 $cats = get_categories(array(
          'child_of'=>1
       ));

See Codex here.

Related Posts:

  1. How to create an automatic MultiColoumn MegaMenu with Categories WordPress
  2. Is There a Difference Between Taxonomies and Categories?
  3. List all subcategories from category
  4. How To Find Out WordPress Category Table in MYSQL?
  5. Add custom field to Category
  6. Get Category ID inside Category template
  7. Only one category per post
  8. WordPress Multisite – global categories
  9. Get the children of the parent category
  10. Get posts from sites in Multisite?
  11. WP REST API: filter by category 1 AND category 2
  12. How To Get Parent Category Slug of Current Post
  13. Display All Products by Category with WooCommerce
  14. What is the difference between a “tag” and a “category”?
  15. Is there an easy way to make a meta box have the tabs like the Categories meta box has?
  16. How to check if I’m on the last page of posts?
  17. Display posts from the same category using next/previous post link
  18. How would I get a taxonomy/category list inside a Gutenberg block?
  19. Can I set a default featured image for a category?
  20. Check if a post is in any child category of a parent category
  21. How to export and import taxonomies (category, tag and/or custom taxonomy) and their terms
  22. Force category choice before creating new post?
  23. Gutenberg editor add a custom category as wrapper for custom blocks
  24. WooCommerce: List All Categories
  25. How to get category and archive title?
  26. Get category ID from category slug (not working)
  27. How do I remove “Uncategorized” from posts with more than 1 category?
  28. Get rid of WordPress category, tag and author archives?
  29. Individual rss feed entry length for categories?
  30. How can I create a category landing page followed by pages of posts?
  31. Remove parent category from permalink? Basically only have the child category?
  32. Custom permalink structure leads to be 404 on pagination
  33. Retrieve Product category ‘NAME’ by product category ID – WooCommerce?
  34. Posts URL structure like site.com/category/the-post-title
  35. Can’t custom taxonomies have same terms (slugs) as categories?
  36. How to get permalinks with category base working with sub-categories
  37. How to remove the term “category” from category pagination?
  38. Using wp_category_checklist in a widget
  39. WP 3.9 TinyMCE no longer loads on category description editor
  40. On the category page, get the category object
  41. Get only the top level categories using get_categories() without foreach loop
  42. Get all categories and posts in those categories
  43. How to add featured image for category (without a plugin)?
  44. How to create a custom sort for WordPress categories
  45. How to display non-hierarchical taxonomy as terms with checkboxes?
  46. Category archive by year with permalink support /category/YYYY
  47. Best Way to Redirect Category to Page and Hide Category
  48. get_terms vs. get_categories: does it matter?
  49. What is a good robots.txt?
  50. Allow users to create their own feed from selected categories?
  51. Hook when category is added to post
  52. get_categories for custom post type with a specific custom taxonomy attached
  53. Add a URL prefix to permalinks of one category of posts only
  54. How do you add categories to custom post types in WordPress?
  55. Create a category list page
  56. Catch 404 after changing permalink structure from /%postname%/ to /%category%/%postname%/
  57. Woocommerce get category image full size
  58. exclude category from get_posts?
  59. How To Modify The Loop in archives.php To Have 11 Posts Per Page and CSS Styling
  60. How can I hide a category from Contributors in the edit/add new post screen?
  61. Order get_terms() By Custom Field
  62. WordPress Multiple Category Search
  63. Should category.php and The Loop be used if the query needs to be customizable?
  64. How do the ‘tag’ and ‘category’ (default) taxonomies do ‘save_post’ action?
  65. How to Change the Categories Order in the Admin Dashboard?
  66. Control term order on a per-post basis
  67. How to remove categories filter from wordpress admin?
  68. get all tags from category
  69. Could not insert term into the database
  70. How can I add the featured image functionality to a custom taxonomy?
  71. Activate Gutenberg in category-descriptions
  72. Filter by post category in Media Library
  73. Filtering categories in the permalink structure
  74. Share one taxonomy across multiple blogs in 3.0 [duplicate]
  75. 404 Error On Category and Tags Pages
  76. How to show subcategories in categories else show posts
  77. Allow duplicate permalink slugs for posts in different categories
  78. Exclude the category from the WordPress loop
  79. get_categories hierarchical order like wp_list_categories – with name, slug & link to edit cat
  80. How to make child categories recognize parent’s template displays
  81. Force WordPress to Show Pages Instead of Category
  82. Completely disable categories
  83. How do I get the category URL from get_the_category?
  84. Display Image for a category using get_categories, or show an image from any child post
  85. Remove / Rename Uncategorized Category In WordPress
  86. Fixing category count
  87. Change Gutenberg category checkboxes to radios
  88. Can a Child Category Have More than One Parent?
  89. is_category() in pre_get_posts strange error
  90. Combine two taxonomies in a hierarchical tree
  91. Checklist of selected categories
  92. How to get posts from two categories with WP_Query?
  93. Group WP_Query by category
  94. Multisite – Protect categories from deletion?
  95. Decreasing the Memory Consumption of a WordPress Site?
  96. How do I use the same post slug for different Categories?
  97. Where/how are categories stored?
  98. How to display only 3 main categories, separated by commas, since they are marked in the post?
  99. Get top parent category
  100. How can I make post fields required in WordPress?