例如，您可以加入另一个表

You could join on another table, for example

SELECT * FROM menu
INNER JOIN order_items ON menu.item_id = order_items.item_id
WHERE order_id = 123;

或者只是将它们复制到您的应用程序中.

Or just duplicate them in your application.

您实际上不需要做您所要的事情.

You shouldn't really need to do what you're asking for.