在单个查询中从ID获取相关数据的最佳方法是什么？

I have a table where each row has a few fields that have ID's that relate to some other data from some other tables.I have a table where each row has a few fields