Store array in sql query -

The title of my question can not really describe my problem. I am undertaking the database module, I have two tables to be able to complex my SQL query and in a single question

Category

• catid int
• catname varchar

  Another table product

• Productid int
• Catid Reference Category (Catid)
• Product Name

  I now select one I want to make a statement which chooses the name of the cat + under that cat Is it possible to do this in any query such as

    SELECT a.catname, (b.productname bla bla in an array) category a, product b WHERE a.catid = B If this is possible please help me   
   
    
  > 
   MySQL - Use  
    Select a.catname, group_concat (b.productname) in the product names from an internal product included on the product b a.catid = b.catid group a.catname