SELECT h.HeadOfHouseholdID,
SUM(CASE WHEN p.DependancyType = 'تحت تکفل' THEN 1 ELSE 0 END) AS Dependants,
SUM(CASE WHEN p.DependancyType = 'غیر تحت تکفل' THEN 1 ELSE 0 END) AS NonDependants
FROM
HouseholdHead h
JOIN
HouseholdMembers p ON h.HeadOfHouseholdID = p.HeadOfHouseholdID
GROUP BY
h.HeadOfHouseholdID;