Hi,
1. Take the Query Activity In the Workflow.
2. Select Recipients as Targeting Dimension and Recipient Delivery Logs as Filtering Dimension as shown below :

3. Not Add the query given below. (Primary Key Of Recipients = Required Primary Key). And this will fetch all the records of Delivery Logs from the Recipient ID of Recipient Table.
Note # Select Primary Key Column Of Recipients Table

OR
If you want to fetch only the counts through database, then use the below query to fetch the counts :
SELECT COUNT(*) FROM NMSBROADLOGRCP WHERE IRECIPIENTID='123'