How to get url by post_id in a loop?

Question

WordPress

I get the values ​​from the Wordpress database like this:

global $wpdb;
$world_table = $wpdb->get_results( "SELECT * FROM subjects " );
$content = '';
foreach ( $world_table as $item ) {
$content .=  " $item->post_id $item->subject "; 
}
return $content ;

Is it possible to get with this code not a post_id, but a link to a post with this post_id?

Answer 1

Links are not protected in the database, only the guid, the url is obtained like this
get_permalink($post_ID);