列出所有父层的清单,并注明它儿子的数量

PHP&MYSQL, Solution, cooode Add comments |
select ks.id, ks.keyword, count(d.keyword) as count1 from
(select id,keyword from keywords where pid=『父亲ID』) ks
left join keywords d on d.pid=ks.id group by ks.id

Leave a Reply

You must be logged in to post a comment.


Powered byWordPress 2.6.2 | Theme by N.Design Studio | Processed in 0.27 秒 苏ICP备07500719号

Entries RSS Comments RSS 登录
Links to Page