How to split column in SQL server

See more:

SQL-Server

My query as follows

select a.years,
 b.season,b.cooperative,
 c.itemcode,
 d.groupname,e.location,a.status from [transact].[transaction_item] a,tbl_farmerregistration_ivorycoast b,[master].[transaction_item_type] c,[master].[transaction_item_group] d,[master].[transaction_location_item_type] e
 where a.transactee_id = b.farmersapcode 
 and a.item_type_id = c.item_type_id
 and a.item_group_id = d.item_group_id
 and e.transaction_item_id = c.transaction_item_type_id 
 and a.status = 'new' and b.isactive = '1'

when I run the above query shows output as follows

Years season      cooperative     itemcode  groupname status
 
  2019  2018   1148339 - Ferke        2       Val       New

I want to display cooperative with two column name

I want the output as follows

Years season      cooperative     id      Name         itemcode  groupname status
 
  2019  2018    1148339 - Ferke    1148339  Ferke        2       Val        New

What I have tried:

From the above query what changes I have to made to get the ouput.