title: Mysqli recursive delete on same table
body: <p>I have comment system with table like this .
  <a href="https://i.stack.imgur.com/wQldr.jpg" rel="nofollow noreferrer">Table Design Image</a></p>
  
  <p>If a person delete the comment then all the row associated with that comment_parent also get deleted </p>
  
  <p>i can write php recursive function which select the row and delete it .</p>
  
  <p>The problem is if the comment has more than 100 of comment_parent, then more than 100 query will run to delete that.</p>
  
  <p>Is it possible to delete comment along with its comment_parentid only with sql query , it will be great if anyone can help , i search and found CTE (but it doesn't support in mysqli i think). </p>