SELECT *
FROM post as P
WHERE P.news_id IN (SELECT N.news_id FROM news as N WHERE N.cate_id = 1)