使用sp_send_dbmail向数据库查询的多个收件人发送电子邮件的存储过程

Like the title says, I'm trying to make a stored procedure used to send emails to addresses stored in the database, often including multiple recipients. I've tried a few approaches to this, but I think I'm hitting a wall and would appreciate any input anyone has. The main issue I've had is querying the database for the addresses and passing that to sp_send_dbmail in a way that works.Like the title says, I'm trying to make a store