sequlize left join 怎么写？有大佬讲解下？

SELECT 
users.id,SUM(b)
FROM 
users LEFT JOIN c 
on c.d like CONCAT(users.d,'%')
GROUP BY users.id