mysql 同一字段 同时满足2个条件查询

SELECT
a.id,
a.post_id,
a.category_id,
a.list_order,
a.`status`,
a.is_show
FROM
cmf_portal_category_post AS a
INNER JOIN cmf_portal_category_post AS b ON a.post_id = b.post_id
WHERE
a.category_id =5 AND b.category_id = 10

关联查询，同一张表