Greetings earthlings.

Im trying to make "Categories" only show ones that have atleast 1 "Posts" assigned to them. In other words, it won't list a Category if it is empty.

My problem is I have two tables. I have this totally wrong, can anyone give me some advice?

Code MySQL:
SELECT
    c.id, 
    c.title
 
FROM 
    categories AS c
 
WHERE
    (
        SELECT     
            p.assign_category 
 
        FROM 
            posts as p
 
        WHERE 
            COUNT(p.assign_category) > 1
 
    )