GROUP_CONTACT value use as a condition with other column

I have one case where I want to use group_contact value as a condition with other column.

please have a look the following code which I applied but return reference to group function.

take an one example as following.

SELECT 
    GROUP_CONCAT(id) AS loca_id,
    (SELECT 
            SUM(loc.total_qty)
        FROM
            locations_assign AS loc
        WHERE
            id IN (loca_id)) AS pend_qty
FROM
    locations_assign
WHERE
    putaway_type = 3

Is there any way where I can achieve this ?

Please help me for the same.

via Chebli Mohamed