select *, (select count(*) from cr_keywords where parent_id = ck.keyword_id) as children_count from cr_keywords ck where parent_id = :keyword_id order by heading