You'd set PLAN_ID_HERE to the free plan you're wanting to check against. It should then output the users who have a subscription of any kind to PLAN_ID_HERE and do not have an active subscription to any other plan. Note there's 2 places to replace PLAN_ID_HERE in the above query.
You can use the CBSubs > Import functionality to mass subscribe them as needed.