I have two tables one for product and another is category

I have a table with category and subcategory field. I want the summation of different subcategory under a particular category. Like Table

```
cat_id| category | 
------+--------------+--
1     |  Cloth       |  
2     |  Food       |  
3     |  Fuel        |  
4     |  School      |  

```

and another one is product table

```
  id|    name   |  cat_id |
 ------+-----------+---------+--
    1  |  skirt    |  1
    2  |  shirt    |  1
    3  |  St Xavier|  4
    4  |  Petrol   |  3

```

Now i want result to be

```
  id  |    name   |  cat_name |
------+-----------+---------+--
   1  |  skirt    |  Cloth
   2  |  shirt    |  Cloth
   3  |  St Xavier|  School
   4  |  Petrol   |  School

```

What will be the My Sql Query for it, Kindly help !!!