So you want to repeat the company_parent_id according to the number of occurances in the company table?

How about ...
Code:
select company_parent_id
from   company
order by 1