title: To fetch value with comma separated ID with Join two tables in MySQL
body: <p>I have 2 tables shown as below</p>
  
  <p>product_category Table</p>
  
  <pre><code>╔═════════════╦═════════════════╗
  ║ category_id ║    parent_id    ║
  ╠═════════════╬═════════════════╣
  ║ 1           ║ 8,7             ║
  ║ 2           ║ 8               ║
  ╚═════════════╩═════════════════╝
  </code></pre>
  
  <p>product_category_description Table</p>
  
  <pre><code>╔═════════╦═══════════╦═════════╗
  ║ id      ║category_id║ name    ║
  ╠═════════╬═══════════╬═════════╣
  ║ 1       ║   1       ║ Test    ║
  ║ 2       ║   2       ║ Test1   ║
  ║ 3       ║   3       ║ Test2   ║
  ║ 4       ║   7       ║ Test3   ║
  ║ 5       ║   8       ║ Test4   ║
  ╚═════════╩═══════════╩═════════╝
  </code></pre>
  
  <p>I want output shown below   </p>
  
  <pre><code>    ╠══════════╬═══════════════╣
      ║ 1        ║ Test4, Test3  ║
      ║ 2        ║ Test4         ║
      ╚══════════╩═══════════════╝
  </code></pre>
  
  <p>I have tried below query but not working:</p>
  
  <pre><code>SELECT GROUP_CONCAT(b.category_name) cat_name 
  FROM  product_category  a 
  INNER JOIN product_category_description b 
  ON FIND_IN_SET(a.parent_id, b.category_id) &gt; 0 
  GROUP   BY b.category_id
  </code></pre>