Weird MySQL index thing

index.sql

SELECT main.id, (
  SELECT SUM(group_member.col)
  FROM tbl AS group_member
  WHERE main.id = group_member.id OR main.parent_id > 0 main.parent_id = group_member.parent_id
) AS col_sum
FROM tbl AS main
ORDER BY id DESC
LIMIT 50;