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
关联查询,同一张表
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
关联查询,同一张表