SET @child_id = 4;
  SELECT  @child_id 
	   	, @child_id := (SELECT ASG_PARENT  
					    FROM  
						  asgrp  
					    WHERE  
						  ASG_ID = @child_id 
					    LIMIT 
						  1)
   FROM 
	  asgrp 
   WHERE @child_id IS NOT NULL 

  SET @child_id = 4;
  SELECT tableconstuctor2.* , @child_id 
	   	, @child_id := (SELECT ASG_PARENT  
					    FROM  
						  asgrp  
					    WHERE  
						  ASG_ID = @child_id 
					    LIMIT 
						  1)
   FROM 
	 tableconstuctor2 RIGHT JOIN asgrp ON tableconstuctor2.T2_ASGRPID = @child_id 
   WHERE @child_id IS NOT NULL ORDER BY T2_SORT

@child_id := (SELECT ASG_PARENT  
					    FROM  
						  asgrp  
					    WHERE  
						  ASG_ID = @child_id 
					    LIMIT 
						  1)