are you looking for this type of output?

let me know.

declare @table1 table
(
	catid int,categoryname varchar(100)
)
insert into @table1
select 1,'cricket' union all
select 2,'football'

declare @table2 table
(
	sid int,catid int,subcatgoryname varchar(100)
)
insert into @table2
select 1,1,'bowling' union all
select 2,1,'batting' union all
select 3,1,'fielding' union all
select 4,2,'foul' union all
select 5,2,'goal'

declare @table3 table
(
	adforumid int,memberid int,adforumname varchar(100),activesstatus bit
)
insert into @table3
select 1,1,'inform',1

declare @table4 table
(
	adinfid int,adforumid int,cid int,sid int
)
insert into @table4
select 1,1,1,1 union all
select 2,1,1,2 union all
select 3,1,2,4

declare @table5 table
(
	memberid int,membername varchar(100),firstname varchar(100),lastname varchar(100)
)
insert into @table5
select 1,'john','paul','stepen' union all
select 2,'andrew','sam','winson'

--[1| cricket,1| bowling,2| batting]
DECLARE @Data VARCHAR(1000)
SET @Data=''

select '['+CAST(t1.catid as varchar(10))+'/'+t1.categoryname+','+Cast(t2.sid as varchar(10))
+' | '+t2.subcatgoryname+cast(t2.sid as varchar(10))+']'
from @table3 as t3
inner join @table5 as t5 on t3.memberid=t5.memberid
inner join @table4 as t4 on t3.adforumid=t4.adforumid
inner join @table1 as t1 on t4.cid=t1.catid
inner join @table2 as t2 on t4.cid=t2.catid
where t3.activesstatus=1
GROUP BY t1.catid,t1.categoryname,t2.subcatgoryname,t2.sid

--output
--(No column name)
--[1/cricket,2 | batting2]
--[1/cricket,1 | bowling1]
--[1/cricket,3 | fielding3]
--[2/football,4 | foul4]
--[2/football,5 | goal5]