select * from categories_description a left join categories b on a.categories_id=b.categories_id where b.parent_id='' limit 0,9