Table1 Has Some data as Categories

![Here is my table1 ](https://i.stack.imgur.com/yNHVy.jpg)

Table2 Has Some data Which is Realated to table1 Categories
![Here is my table2](https://i.stack.imgur.com/J8RhU.jpg)

and the relation between two tables is cat\_id from table1 and cat\_ids from table2.

What I want is? 
I need to display all fields in table1 and from table2 I need only the related content i.e id's present in cat\_id(table1) and cat\_ids(table2)

I am using a query like this `select c.* ,cc.* from news_categories cc, news_content c where cc.cat_id = c.cat_ids group by cc.cat_id` this gives only common data from table1 and table2.. i need common data and all categories from table1
can anyone help me?