benecaster_get_member_thanks_rows()

Turns a list of user IDs into fully described Member Thanks rows. For add-ons registering a custom query type: your query decides who, this decides how they are described.

Filling those fields by hand means a five-way join — the tokens table for the tier, the users table plus three meta rows for the display-name resolution chain, and a grouped subquery over subscriber events for the join date. Reimplementing it is how a custom query type ends up emitting empty strings for tier_slug and joined_at, and rendering blank fields under a “thank you” heading.

It uses the same name-resolution chain and the same join as core’s own query types, so a custom type describes its members identically to a built-in one.