SQLのCase文で結果を分岐する

SELECT 
 CASE WHEN parent_id IS NULL THEN id 
      ELSE parent_id 
 END AS related_id, *
 FROM table_name ORDER BY related_id;