select pd.categories_id   as parent_id,
       pd.categories_name as parent_name,
       cd.categories_id   as child_id,
       cd.categories_name as child_name
  from categories_description as pd,
       categories_description as cd,
       categories as c
 where pd.categories_id = c.parent_id
   and cd.categories_id = c.categories_id;