As long as you use WP API ($wpdb) to perform queries, they will be cached by caching plugins (well, by those that have such functionality).
If you need to cache data that is more compelx to generate rather than just retrieve look into Transients API.