Total Payment BY User

SELECT CONCAT(f.name) AS member, f.uid AS uid, SUM(a.field_amount_value) AS amount FROM `node__field_month` m 
LEFT JOIN taxonomy_term_field_data t ON m.field_month_target_id=t.tid
RIGHT JOIN node__field_member u ON u.entity_id=m.entity_id
LEFT JOIN users_field_data f ON u.field_member_target_id=f.uid
LEFT JOIN node__field_amount a ON m.entity_id=a.entity_id
LEFT JOIN node__field_credit_date r ON m.entity_id=r.entity_id
GROUP BY Member