Select Query to get child rows from a table having parent-child relationship in SQL Server

Refer this

INSERT INTO [tblUserLogin]([RefLoginID], [ParentUserID] ,[UserName]) VALUES (6,0,'Anil')
GO
INSERT INTO [tblUserLogin]([RefLoginID], [ParentUserID] ,[UserName]) VALUES (8,1,'Rakesh')
GO
INSERT INTO [tblUserLogin]([RefLoginID] ,[ParentUserID] ,[UserName]) VALUES (9 ,1 ,'Varun')
GO
INSERT INTO [tblUserLogin] ([RefLoginID] ,[ParentUserID] ,[UserName]) VALUES (11 ,1,'Raj')
GO
INSERT INTO [tblUserLogin] ([RefLoginID] ,[ParentUserID] ,[UserName]) VALUES (14 ,0 ,'Minit')
GO

SELECT * FROM [tblUserLogin] 
WHERE RefLoginID = 6 
	OR ParentUserID = 1